Macro Condition

[eww]

I've got a check box that I've set up with an embedded macro that when clicked sets the enabled property of another field to "true". However, I noticed that if the box was clicked again that field would still be enabled.

I tried using a condition on it to say (it's a checkbox for a if a seperate address is required) [SeperateSubmittalAddress]="Yes" but this does not seem to work at all.

[pbaldy]

Try without the quotes around Yes. With quotes you are comparing to a literal string, not a Yes/No value.

[NTC]

What occurs to me in reading your post is that you have an event trigger and vb to make it 'true'.

But I don't read where you have an event trigger and vb to make it 'not true'. Checking that same box again will not return it to 'not true' if there is not the vb to do so... perhaps I'm missing something on this point. maybe this helps.

[weekend00]

Totally agree with NTC.

But I don't think [SeperateSubmittalAddress]=Yes will work, Yes is not defined by Access, not like true or false.

[eww]

NTC, you're totally right. Didn't even think of that and it makes total sense, AND it works. Thanks a bunch .

And it does work as [SeperateSubmittalAddress]=Yes just for future reference in case anyone else has problems with this. Although I just saw that you use Access 2003 (while I'm using '07) so there might have been a few changes made in that area, I'm not sure.

[weekend00]

All right. my mistake.