Check Boxes

Allan320 · June 1st, 2006, 05:12 AM

I have a check box that i need to reset after i execute a query. Is there some VB code that i can use to do this. I cant seem to find this.

Thanks

Allan

SerranoG · June 1st, 2006, 07:51 AM

If you're talking about a form, you just reset it to whatever you want. Suppose the checkbox is named MyCheckBox, then in your code you put

Me.MyCheckBox = False

or whatever your default is.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Allan320 · June 2nd, 2006, 03:43 AM

I have a check box on a form, and i want it, when i click the checkbox, it automatically checks yes in a corresponding field in another table. I have a clients table and a clients form, when i click update i want it to check the update field in the clients table, so that it is picked up by my query?

Thanks. This is annoying me now :D

Allan

Allan320 · June 2nd, 2006, 05:45 AM

Right. I have fixed the question above!!! (woo hoo). Next one. I have a button which i have to click, when i click this i would like it to set the value of the checkbox to checked. Here is the code for the Main button

Code:

Private Sub Update_Act_Click()

DoCmd.TransferText acExportDelim, , "Act Query", "C:\Act Update.csv"
Launch_Act

here is the check box

Code:

Private Sub Check296_BeforeUpdate(Cancel As Integer)
On Error GoTo HandleErr
    Cancel = CheckHeadOffice
ExitHere:
    Exit Sub
    End Sub