for KLATUU

[Guest]

I got the Option Group with two Option Buttons (one for 'Yes' the other one
for 'No'). I am not sure where to put the piece of code you gave me:

If Me.opgYesNo = True Then

'Do the Yes Stuff
Else
'Do the No Stuff
End If

Also, who do I link the option group or the yes and no option buttons to the
querry? I have a field in the querry that the data is either yes or no. If
the used clicks the yes option in the form, I want to get all the 'yes' in
that field. If the users clicks 'no' I want to get all the 'No'

 

[Guest]

This is what I plan to do:

I have a querry with one field. The field's values are either 'YES' or 'No'.

Also, I have a form with a check box.

If the user checks the check box and hits the OK button in the form, I want
all the records that have a value of 'YES' in the querry to be shown. On the
other hand, if the user unclicks the check box and hits the OK button in the
form, I want all the records with a 'NO' value to be shown.

I need to know how to link this check box to the field in the querry. One
last thing, the 'YES' and 'NO' values in the querry and text values, not -1
and 0 access values.

I hope you can help me.

Thanks