Check Boxes

[Dave14867]

Hello All,


I haven't been here for a while but most likely will be for some time as I am working on a new database and haven't done so in a couple of years.

My issue right now is I have 2 check Boxes on a form and I want them to work such that if 1 is checked the other is not checked and vice versa.

Here is what I thought would work but it doesn't.

'If Hourly = -1 Then
' Salary = 0
'End If
'
'If Salary = -1 Then
' Hourly = 0
'End If


I have also tried

'If Hourly = True Then
' Salary = False
'End If
'
'If Salary = True Then
' Hourly = False
'End If



Thanks in advance
Dave

[CJ_London]

why not use an option control instead? Or just one checkbox - hourly=0, salary=-1

But if you want to store two value rather than one

in the salary checkbox afterupdate event put

hourly=not salary

in the hourly checkbox afterupdate event put

salary=not hourly

[Micron]

Or put the checkboxes in an option group (frame) and they'll behave the same as option buttons - no code for setting T/F?
But maybe that is what was meant by an "option control"...

[Dave14867]

CJ_London,
I tried your suggestion and it doesn't work, I get an Error "Microsoft Access cannot find the Object "Salary=Not Hourly"

Micron, I have never used a frame before

[Dave14867]

Can't this be done with an If statement?

[Dave14867]

Got it Resolved, Thanks

[Micron]

Learn Something new everyday. A day in which you learn nothing is a wasted day.

You can help someone who comes across this in the future to do that by always posting your solution.
Thanks.

[June7]

Do you have two yes/no fields - Salary and Hourly? Why not 1 text field and a combobox with choices of S or H? Or one yes/no field as suggested by CJ?

[CJ_London]

But maybe that is what was meant by an "option control"...

yes - was on my phone at the time