On 18/02/2015 15:23, Ian Whitfield wrote:
*Hi All*

I have been rebuilding/revamping my Database over the past few weeks and everything has been going great.
I'm using LO 4.3.5.2 and MySQL 5.1.73 on PClinuxOS (latest).

Yesterday I found I had not set my Keyfield (RecordID) to Auto Increment so I set a new field with phpMyAdmin called 'id'. And this is now working fine and Auto incrementing. I deleted the old RecordID field.

Now many of my fields are greyed out in the Form and will not accept input and all my drop-down boxes are inactive.
probably in your "data" properties from the greyedout ListBoxcontrols you have used in a sql statement the name off the deleted field or the data connection is based on this deleted fields ?

Hope it helps

fernand

I created a new temporary Form (using the Wizard) and it works fine and displays all fields. But as soon as I replace a field with a drop-down or Combo Box box that box becomes inactive again and is greyed out and will not display the options.

I've looked everywhere in the field properties but can find no obvious cause.

Anyone have any ideas please?? Thanks.

IanW
Pretoria RSA





--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Reply via email to