Checkboxes question

[Guest]

Here is what I would like to do.

I have an access database that I use to keep track of members and their
interest in certain sports. What I want to do is to take 2 checkboxes (yes/no
fields) and create a third so that if either Checkbox 1 or Checkbox 2 is
checked, there will be automatically a check in box #3. If there is neither
a check in boxes 1 or 2, there should not be one in #3.

How would I get this to work?

Thanks!

 

[Van T. Dinh]

Use the AfterUpdate Event of the CheckBox1 and CheckBox2 to check the values
of these and set the value of CheckBox3 accorsingly.

HTH
Van T. Dinh
MVP (Access)

 

[Guest]

hI this will help you..

make an event in the form on timer, put in Time Interval: 1000
Private Sub Form_Timer()
If checkbox1.Value = True And checkbox2.Value = True Then
checkbox3.Value = True
End If


End Sub




(e-mail address removed)

 

[Guest]

Sorry for my ignorance, but where do I put this?
The data is in an Access table.

Thanks!

 

[Van T. Dinh]

You need to use an Access Form which has Events that you can use as triggers
to run the required code.

You cannot do this in the DatasheetView of the Table.

 

[Guest]

I also use this database as the database for my .asp website. Will this auto
run? Or how exactally will it work to keep the 3rd check box up to date?

Thanks.

 

[Van T. Dinh]

Sorry, I don't know a thing about ASP.