Change lable to Visible if a record matches a record from another table

[craig1988]

Hi

This should be an easy one.

I have a form that is bound to a query "qryExceptions". The field I am concerned with is "AccNo". As the user toggles through the form I would like a lable "lblSpec", that I would like to be visible if the "AccNo is contained in another table "tblSpecialPrint". The lable would then return to invisible when the user toggles further.

Hope somebody can help me!!

[pbaldy]

See if this helps:

http://www.baldyweb.com/ConditionalVisibility.htm

Using a DCount() to test against the other table.

DLookup Usage Samples

[craig1988]

Hi pbaldy

Thank you.

I was on the right track with my DLookup but had forgot to assign some criteria!! Thanks for jogging the memory!!

Craig

[pbaldy]

Happy to help Craig!