I have a form in Access 2000 that if opened specifying the where command
the comboboxes will not update the database when you first pick an item,
it will default back to its original value. The next time you pick an item
it will set the value. If you try and set it a 3rd time it will stay at
the 3rd value and then the 4th time it will update. Has anyone seen this
or have a fix? If I do not specify the where command when opening the form
it works fine. I have found that if I open the form without the where
command and then apply a server filter it will work fine.