Report controlling a field

[SpandexBobcat]

Hi gang,

I have a couple of questions regarding reports.

Firstly, how do I get a switchboard button to print a report

Secondly, I automatically need a yes/no field (paid) on table OVERTIME to change from no to yes when this has been printed.... How do I do that???

Regards,

SB

 

[TwoOdd]

Using the switchboard manager, you can edit a current button or create a new button and choose the option to open a report and select the report to be opened.

In the report On Close event, you can write a sql statement to update the OVERTIME table where EmployeeID is the Primary Key and is a field on the report:

UpdateTxt = "UPDATE OVERTIME SET OVERTIME.paid = -1 WHERE OVERTIME.EmployeeID = " & Me.EmployeeID
DoCmd.RunSQL UpdateTxt

Hope this helps,


TwoOdd
--------------
Good judgment comes from experience, and experience comes from bad judgment.
-- Barry LePatner