Report Coding

  • Thread starter Thread starter K crofts
  • Start date Start date
K

K crofts

I have a command button on my form (''Print10a''). I want
to be able to click this button and print the report
(''10aConfirmation'') twice but only for the current
record. My whole database is defined by the selected date
in my textbox (''DateField''). As i am new to access i
would really appreciate some help in coding this/setting
it up. Dont know if it makes a difference but my report
does display teh selected date and todays date in the
detail section.
Any help appreciated.
 
K,
I think you're saying that each record in your database has a unique
[DateField]?
If so...
Use a query as the Recordsource for your report, and in the DateField use
this criteria (use your own names)
= Forms!Print10a!DateField
When the report runs, only the record associated with the DateField on
the active form will print out.
hth
Al Camp
 
Back
Top