Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Posts
    3

    Unanswered: Error 2118 on listbox requery.

    I am creating a database that has a listbox which queries a table to populate itself. It requeries based on the OnTimer event of the form it resides on, with a timer interval of 1000ms. Every once and a while, this error appears, and I cannot figure out why. Any help is appreciated.

  2. #2
    Join Date
    Apr 2002
    Location
    Germany
    Posts
    228
    "The action 'Requery' can't be executed as long as the field is not saved" (or something like that, translated from German)

    Looks like you have unsaved data entered in the control at the time you try to requery it. If you execute a requery at that point access doesn't know what to do with the data. Try to run a RunCommand acCmdSaveRecord or issue an undo before you execute the requery.

  3. #3
    Join Date
    Jul 2002
    Posts
    3
    Thank you, the "RunCommand acCmdSaveRecord" worked

    Though, I still don't understand the problem. I discovered that the error appears every time I click on the listbox at the same time as it is requerying. Why would that be?

Posting Permissions

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