Automatically view the latest records for a form

You can automatically view the most current data for a form by refreshing and requerying the records.

If you're using a database that's shared on a network, you can view the latest version of existing records by creating a command button that updates form data.

To display the latest set of records in a form, including new records, you can requery the records by adding the Requery action to a macro or by adding the Requery method to a Visual Basic procedure.

What do you want to do?

Create a command button that updates form data

Automatically view the latest records for a form by using a macro

Automatically view the latest records for a form by using Visual Basic for Applications