closing form

[Will]

Hello,

i am trying to uncheck(checkbox) all selected record in a continous form
using the close event of the form. can anyone help with this.....

thanks

 

[Craig]

Try this:Use the recordsource of your continous form and create and update
query.
Example:
dim sSQL as string
sSQL="UPDATE PurchaseOrders SET Ordered = False
WHERE Ordered=True
Docmd.runcommand RunSQL

I you don't want the msgboxes add lines before and after for
Docmd.setwarnings false before and true after the code.

 

[Will]

Sorry, i am very new to this stuff, and i am wondering if that code should go
within the select statement.
my current record source is the table ProdHistory and the item that i want
to diselect is ckselect.

thanks for your help.