Error message 2118--You must save field

  • Thread starter Thread starter D Collins
  • Start date Start date
D

D Collins

Hello,

I have two list boxes--one with available items and the
other with selected items. I used code from an Access 97
book that demo'd the selecting of items from the first
list box by double-clicking--then the item moves over to
the other list box. I've used this technique before with
no problem, but it is now giving me this error:

You must save the current field before you use the
requery action (2118).

Do you think it has something to do with the fact that
I'm using it with a different version Acces (2003) rather
than Access 97?

Or, is there a simple line of code that will save the
field. I did try putting in a save command to no avail.

Thanks,
D.
 
Were it happening to me, the first thing I'd try is adding a breakpoint into
the code that runs, so that I could step through the code to find where the
error is happening.
 
Back
Top