check box issue

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

Guest

I had created a checkbox in Access 2002 and I was able to set it an option
value
However when i try to create a checkbox in Acess 2003 I cant set its option
value. Does any one know how to set option value = 1 for checkbox
Also i had written some code to query based on checkbox value that seems to
not run in access 2003
If Me.Select = 1 Then
sel = "Priority = '" & Me.Input & "'"
ElseIf Me.Select = 2 Then
sel = "Status ='" & Me.Input & "'"
ElseIf Me.Select = 3 Then
sel = "AssignedTo ='" & Me.Input & "'"
End If

Select does not seem to be recognised in Access 2003. Does any one know what
the solution to this would be.
Thank you
 
Saj said:
I had created a checkbox in Access 2002 and I was able to set it an option
value
However when i try to create a checkbox in Acess 2003 I cant set its option
value. Does any one know how to set option value = 1 for checkbox
Also i had written some code to query based on checkbox value that seems to
not run in access 2003
If Me.Select = 1 Then
sel = "Priority = '" & Me.Input & "'"
ElseIf Me.Select = 2 Then
sel = "Status ='" & Me.Input & "'"
ElseIf Me.Select = 3 Then
sel = "AssignedTo ='" & Me.Input & "'"
End If

Select does not seem to be recognised in Access 2003. Does any one know what
the solution to this would be.
Click to expand...


A check box only has an OptionValue property if it's
included in an option group frame. From your code above it
looks like the frame was named Select, but you forgot to
create it on the 2003 form, so the check boxes are not in
the non-existent frame.
 
Back
Top