Current Records print

  • Thread starter Thread starter Michael Lam
  • Start date Start date
M

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
 
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?
Click to expand...

Almost! It should be Forms not Form.

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