Current Records print

[Michael Lam]

I have created a form to allow user to keyin value
After click the save /Add records button , Autogen Ref No will be assigned
to this records

I want to create a buttons to print out current records only ? How ?

I have created a query to select the current records by Ref No
how can the new created Ref No pass value to the query ?
In the query wizard, there is a field called parameter or regulation
I have try to key in as follow

=[Form]![RequestForm]![RefNo]

am I correct?

THX

Michael Lam

 

[John Vinson]

I have created a form to allow user to keyin value
After click the save /Add records button , Autogen Ref No will be assigned
to this records

I want to create a buttons to print out current records only ? How ?

I have created a query to select the current records by Ref No
how can the new created Ref No pass value to the query ?
In the query wizard, there is a field called parameter or regulation
I have try to key in as follow

=[Form]![RequestForm]![RefNo]

am I correct?

Almost! It should be Forms not Form.

Base a Report on this query, and have your button launch the Report.