Referencing search results

[Homegrownandy]

Where I'm at:



*I have a query that returns values into a user form.

*On that form I have added a button next to each record to open a new form... so far so good.

*I don't know how to reference the result next to the button.

What I want:

* The user clicks the button and the new form is displaying details about the record it (the button) is next to.

I plan on using this feature a lot, and I'm sure its pretty simple if you know what you are doing. Sadly I do not. I plan on a user using my search form. They can then open the record from the button and from there add notes possibly.

I try and only include information that is helpful to getting the answer in my posts. If you need any other information to help on the issue just ask.

Thanks, Andy

[ItsMe]

*I have a query that returns values into a user form.

Is this form a Continuous form?

[June7]

Something like:

DoCmd.OpenForm "formname", , , "Id=" & Me.ID

[Homegrownandy]

yes its a tabular form that displays all the results in a list.

[Homegrownandy]

June I'm sorry to say I have no clue what you mean there. Is there a term I can search that would help me understand?

Thank you.

[June7]

That is VBA code for opening a form with filtered dataset. Research the OpenForm method.