Unanswered: You must save the current field before you run the requery command
I am trying to update a combobox after a notinlist event. I am using a form to add the new data as there is two fields. The data is being added to the table but I keep getting the following error when I try to requery the combobox. "You must save the current field before you run the requery command" I have tried placing the requery in a number of places but still without success. Any ideas ??
Maybe because you have a bound combobox that you are loading with a certain field manually using the AddItem method everytime you add a new value the database sees it as you changed that field that is why you get that message.
Try to load the combobox first, then bind the combobox.
Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!
Or try our Ask An Expert service to answer any of your questions!