Navigating to a certain record on Pop-Up Form

[benkingery]

I have a form that pops up from a VBA function on another form. The form that pops up is based on a query that I never want to add values to. The purpose in opening the form is to give a more friendly view of the underlying field since it is a memo field. At any given point, the form that pops up will have a certain number of records in it so the user has to navigate through the records until they find the record they want to view.

Can someone help me with navigating directly to the desired record on the pop-up form? Both forms share a common control called "GroupParent".

Thanks in advance for any help you are able to render.

 

[ajetrumpet]

is there an indicator on the form underneath the popup form that would tell you what record to go to? if so, put the WHERE argument in the docmd.openform code in the function. example:

docmd.openform "myform", acnormal, , _
   "[GroupParent] = forms!oldForm![GroupParent]"

that code will filter the popup form. if you just want a user to search for the record, you can have a text box on the form, and a button next to it that says search. behind the button, put some "search" function, just like pushing Ctrl+F on your keyboard.

 

[benkingery]

This is perfect. Thanks for the help.