Check box issues

[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

 

[Al Campagna]

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]

Seemed to work.

Thanks much

dave

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."

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

 

[tkelley via AccessMonster.com]

Try this:

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

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