Ability to view other records - Open Form in Microsoft Access


	Back to Open Form Comments List

Ability to view other records Upload Images Link Email

Jeff Bartuch

17 months ago

Hello

The code to open a form to a specific record works just fine, but is there a way to use the navigation controls to view the next or previous record? The navigation controls say 1 of 1. I would like to open the detail form to that specific record, but still have the ability to use the navigation controls to view the next or previous records. Can this be done?

	Kevin Robertson 17 months ago
You could click the Filter button to turn the filter off or use Find Record to open the record without the form being filtered. Example: `DoCmd.OpenForm "CustomerF" Forms!CustomerF!CustomerID.SetFocus DoCmd.FindRecord cboCustomers, , , , False, acCurrent, True`

	Jeff Bartuch 17 months ago
Nice work Kevin. You never disappoint.

	Jeff Bartuch 17 months ago
Kevin part B of this question was posted on the 'Only filtered records' forum. Any help you can give me would be appreciated.

	Alex Hedley 17 months ago
Only filtered record

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Open Form.