closing form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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.
 
Back
Top