Check box issues

D

Dave

I have a check box on a form which I want checked based upon the value in
one of 2 checkboxes in a query tier to the form.

I am trying this in the row of the query but it is giving me an error

SentStatus: IIf([EmailedStatus] Or [FaxStatus]=True,True,False)

EmailedStatus and FaxStatus are both fields in the table the query is built
on

SentStatus is the name and control source of the check box on the form

what am I doing wrong in the if statement?

Thanks

dave
 
D

Dave

Seemed to work.

Thanks much

dave

Al Campagna said:
Dave,
Try...
SentStatus: IIf([EmailedStatus] = True Or [FaxStatus]=True,True,False)
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."


Dave said:
I have a check box on a form which I want checked based upon the value in
one of 2 checkboxes in a query tier to the form.

I am trying this in the row of the query but it is giving me an error

SentStatus: IIf([EmailedStatus] Or [FaxStatus]=True,True,False)

EmailedStatus and FaxStatus are both fields in the table the query is
built on

SentStatus is the name and control source of the check box on the form

what am I doing wrong in the if statement?

Thanks

dave
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2010 0
Enable or Disable Checkbox with expression builder 3
Access Form - Lock Fields from Editing 0
Create Check box that controls visibility of a text box or combo b 1
check box simple question 2
Form with check box Help 1
Can a Check Box Prevent Other Fields from Being Used? 1
Check box to control editablility of text box and return all recor 1

Top