Rachel said:
I am using a form to add data. The database is displaying
data at the same time. How can I get the database to
display the newly added data realtime?
How is the database "displaying data"? Do you mean you have a table or
query open in datasheet view? Or is it one or more forms that are also
open? Either way, you have to requery the object(s) in question, but
it's going to be a complicate process unless you're dealing with forms.
Note that requerying a form or datasheet resets the current record to
the first record, so if you want to avoid this you have to take special
steps to get back to the record that was previously current.
Please explain a bit more about exactly what problem you're trying to
solve, and maybe we can come up with a specific solution.
