setting a check box in a different table

[MisterEkted]

I have an invoice form (based on an "invoices" table) where I can select from a list of completed jobs from a "jobs" table. The "jobs" table has a check box "job invoiced?" that I would like to set to "yes" when the "print invoice" event happens.

 

[missinglinq]

To tick the checkbox:

Forms(FormName)!CheckBoxName = -1

To untick the checkbox:

Forms(FormName)!CheckBoxName = 0

The checkbox on the current record of the form holding it will be set, according to which code you use. Be aware that the form holding the checkbox has to be open or the code will throw an error.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[LisaWay]

To update the [JobInvoiced] field in table [Jobs] to "True", you could add the following to your PrintInvoice_Click routine:

    DoCmd.RunSQL "UPDATE Jobs SET Jobs.JobInvoiced = True" & _
        " WHERE (((Jobs.JobID)=" & [comboJobID] & "));"

Note: This assumes that you select the completed job from a combo box named "comboJobID", and that it contains the JobID in the first column.

Regards,
Lisa