MS Access Multiuser - Datasheet appears after requery

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Datasheet appears after requery

CDG

2006-01-22, 8:24 pm

I am creating a database to be used on a multiuser environment. New records
will be added and records will be updated with several users. I have a form
that displays all the records - kind of like a datasheet view. I understand
that I must have some type of requery. Currently, I have a requery command
button that goes to a macro OnClick. The macro performs the function of the
requery. I have several questions:

1. When the command button is clicked, a datasheet appears with the records
listed. When you close the datasheet you are returned back to the original
form. How do I make this datasheet not appear?
2. Is there a way to have the records requery automatically - not use the
command button?
3. After the requery, the cursor returns to the first record. How can the
cursor remain at the current record or at best go to the last record?

Thanks,

Sponsored Links