Hello!
I'm sure there's a tutorial on this somewhere but I've not been able to find it!
I've added a List Box to my form. I make a selection and carry on adding info and all seems well. However, I keep getting an error message saying 'Unable to update current record'.
What have I done wrong? (Old fart making transition from access).
I probably haven't supplied enough info but any response appreciated.
Tim
[Solved] Dropdown list selection not updating table
[Solved] Dropdown list selection not updating table
Last edited by tjsilver on Thu Nov 23, 2017 3:52 am, edited 1 time in total.
OpenOffice 4.1.4 on Windows 10 Pro
Re: Dropdown list selection not updating table
The listbox question is asked almost daily. Just scroll down down the Base forum a little bit.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Volunteer
- Posts: 1549
- Joined: Wed Jun 24, 2015 12:56 am
- Location: Colorado, USA
Re: Dropdown list selection not updating table
Your error might be related to the Primary Key.
The database engine can't Update a record if it doesn't know the Primary Key value for that record.
Is there a control on the form displaying the Primary Key for the table being updated?
The database engine can't Update a record if it doesn't know the Primary Key value for that record.
Is there a control on the form displaying the Primary Key for the table being updated?
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Re: Dropdown list selection not updating table
Thanks for replies. Got there in the end!
OpenOffice 4.1.4 on Windows 10 Pro