Updating fields

[gselliott]

I have got a form that i am using to produce invoices, the user selects each record to be included in the invoice by clicking a check box (Add to Invoice). I have set this is up and works fine, the problem i have now got is that i need to update each record so that once it has been invoiced it will not be availible again.

I have added another check box to the form (Invoiced), what i want is for this to be automatically checked once i close the form (after the invoice has ran). I tried doing this using an IF Statement on after update of the the first check box but of course this doesn't work because it will update both fields and therefore will not be picked up by the query if Invoced has been checked.

Is there some way i can do this, possibly more simple??

I really hope someone can help.

Thanks
Graeme

 

[Mile-O]

Can't you use an UPDATE query?

 

[gselliott]

I thought of using an update query but not sure how to tie it in with the forms i am using? How would i make sure the update query only updated the fields that have been invoiced?