Linking a query name to a form

[jdupaix]

Hey guys, I have a question for you. I have a query that gives me a list of names with info on each person. From the query I want to be able to click on the name of an individual and in turn have the form open up on that individuals page. Allowing me to enter more data and/or see more data on the individual. Thanks for any help you might give!!

Joe

 

[boblarson]

Create a form based on that query and then you can use events to do what you want. You can put on the click event (or double-click event) of the name control and use:

DoCmd.OpenForm "YourFormNameHere", acNormal, , "[YourNameIDFieldHere]=" & Me!YourNameIDField

 

[jdupaix]

Thanks boblarson! I really appreciate it and will give it a try!