Open Specific Record - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Open Specific Record

Joe Hood

5 years ago

Hello Everyone,
I currently use a dbl click event to open a specific customer Record. Once opened it is filtered Record 1 of 1, which will not allow me to navigate forward and backward through the list of customers. If you turn off filtering in the navigation pane it returns you to the first customer in the list. Does anyone know how can I open the record that I want and still have the ability to scroll backward and forward through the entire list.
Thanks,
Joe

Adam Schwanz @Reply

5 years ago

Basically you just need to open the form and then move after.

You might need to adjust this slightly as this is with a subform, but just posting it because I had already made the code for this previously

Using the setup in Open Form as the example

    DoCmd.OpenForm "CustomerContactF", , , "CustomerID=" & CustomerID

    Forms!CustomerContactF!ContactF.Form.Recordset.FindFirst "ContactID=" & ContactID

For a normal form, you should just need to do something like

DoCmd.OpenForm "CustomerContactF"

Forms!CustomerContactF.Recordset.FindFirst "ContactID=" & ContactID

	Adam Schwanz @Reply 5 years ago
Might need to be Form.Recordset.FindFirst, brain isn't working yet today

	Joe Hood OP @Reply 5 years ago
Good Morning Adam, Worked like a charm, your help is very much appreciated. Have a Great Day!

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

Next Unseen

New Feature: Comment Live View