newbie question about report

[Kurbasic]

I am newbie to access, I have database with many yes/no fields. I have to
create report, using form, where users have to select yes/no fields.(OR
clause).
Plesase help.

 

[m.wanstall]

I'm not exactly sure what the problem is here as you don't exactly ask
any questions... By default if you drag any Yes/No field onto a form
you will get a Checkbox (where Checked=Yes and Unchecked=No) however it
sounds like what you are referring to is similar to the Radio Button
"Yes/No" often used in web forms.

To change your Checkbox to a Radio Button simply Right Click on it and
select Change To -> Option Button. This will give you a SINGLE
changeable Option Button however since you want a Yes AND a No simply
drag another Option Button from the tools onto the form and label it
"No" and the previous one "Yes" (and name them optQ1No and optQ1 [or
whatever your bound Yes/No fieldname is] respectively). Go to the
OnClick event of optQ1Yes and go to Code view and write:

If optQ1 = True Then
optQ1No = False
Else
optQ1No = True
End If

Then go to the OnClick Event of optQ1No and put in similar but reversed
logic code:

If optQ1No = True Then
optQ1 = False
Else
optQ1 = True
End If

This is basically a hack...one of the buttons isn't bound to the
database at all, but it will look like it is and it will work
correctly.

Good luck!
-Mal W