Clear a row in a list box after updating a record

[Guest]

I have created a form that automatically lists records in a list box. I press
a button and it populates the text boxes with the information so I can update
the information. However, the row remains in the list box after I push the
Update command button. The text boxes clear the data to recieve a new record.
How do I remove the row in the list box automatically after the record has
been updated?

Sincerely,
James E

 

[Guest]

Hi
using VBA, after update you should flag the done row in the database and
then requery the listbox rowsource. or change me.listbox.rowsourse with a new
query or values.

Nader

 

[Guest]

I created a macros and set it the action to requery and placed the macro in
the After Update in the list box, but it did not work. If you could be a
little more specific in your answer, providing an example I would appreciate
it.

Thanks,
James E.