Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    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 ??

  2. #2
    Join Date
    Mar 2004
    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts