General information
Category:
Coding, syntax & commands
Robert,
If you just "opened" the view on the form and bound it to the listbox, then you have to re-select the view and issue a "REQUERY()" before the listbox will see the changes. If the properties of the listbox are for obj.RowSource = 3 (SQL-Statement), then obj.Requery() should work.
Another possible cause of the problem is table buffering mode... If the form is set for buffering and the record was not committed, any requerying will always go back to the physical table rather than the "in memory" version of the table.
Hope this helps...
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only