One button two functions

[Kerman SPI]

I need a button on my form to do two things. 1. Run an update querie I have
created which updates all records with a specific [CertNumber] to a
[DateIssued]. (Could be 1 to 100 records updated) 2. After update querie
has run, print a report named "Cert Number by date Issued". I have gotten
this to work through a macro combining 1 & 2, but the [CertNumber] is asked
for again (Twice).
Example: Click button: "Please enter Cert Number", "Please enter Date
Issued", and "Please enter Cert. Number". I really dont want to enter the
Cert. Number twice. Any Ideas...Thanks...Randy

 

[SteveD]

Could you have a text box on your form, where the user
enters the CertNumber, then reference that for both the
query and the report.

[forms]![frm_Main]![CertNbr]
would be utilizied in your query and report.

This is where your form is frm_Main and the field on the
form is CertNbr. You can add some vaildation at
the "Update" button if required.

SteveD