Click a button from a continuous form line to open records

[mchadwick]

I have a continuous form with 5 to 10 records in it. Projects.
I would like to have a button on each line of the report that will allow me to open another form with the data in from the record they selected.



Project
Bob 10 record for this project
John 32
Chris 2
Mary 10

I click on the button for the line Mary and another form opens up with only the 10 records from Mary.

I would love to be able to do this with just macro commands but will do what I need to do to make it work. Thank you in advance.

[June7]

So build embedded macro for button click event. Use OpenForm command. Include filter criteria in WHERE CONDITION argument.

What exactly do you not understand about using macro builder for this requirement?

[ranman256]

Docmd.openform “Form2”,,,”[id]=“ & txtID