Automatically Pick up the ContactID in a form

[thuzinec]

On my frmContacts I have a button “Preview BOID Rpt” the button is linked to open a report that is based on the user entering the contacts ID number. I would like to have this button automatically pick up this number (the record that the user is currently on) when the "Preview BOID Rpt" is clicked. Rather than having to enter it manually.

Whoever can help, I would greatly appreciate it.
Thanks!
Terra

 

[fneily]

Well, if your report is based on a query, then in the criteria row under ContactID you could put:
Forms![frmContacts]![ContactID]

The query will run, pick up the ContactID and create a recordset for just that ContactID which will then populate the report.

 

[thuzinec]

Thank you so much! This is just what I’ve been wanting to do with several fields, as well as, buttons. Your terrific!
Terra