opening specific record on a form from a report button

[mainerain]

Click on a button, enter search criteria, report shows results with another button for each line item. I want to click on the line item button which takes me to the form for this line item.



The search criteria is a serial number. There are many Models with serial numbers with their own forms. How do I open the right form with the right serial number?

[ranman256]

open the form using the current record ID,
docmd.openform "fMyForm",,,"[id]=" & txtID

report:

docmd.openReport "rMyRpt",acViewPreview, ,"[id]=" & txtID

[pbaldy]

In case the field is text:

http://www.baldyweb.com/wherecondition.htm

You mention different forms; you'd need some way of identifying which form to open. And we'd be curious why there were different forms for different models.

[mainerain]

Different forms for Models because each Model is different than another with its own unique set of characteristics.

[pbaldy]

I might have gone a different way, but you know your situation better and at this point it is what it is. You still need some way of knowing which form to open based on whatever data is in the initial form/report.