Control Source code

[Bob V]

How can I join these two codes together .....Thanks for any help ...Bob
=IIf([tbGSTOptionsValue]=0,Null,[TaxLabel])
=DLookUp("TaxLabel","tblCompanyInfo")

 

[tina]

well, who knows, since we have no idea what you're trying to do, or where.
what are you trying to accomplish, and what is the setup?

hth

 

[James A. Fortune]

How can I join these two codes together .....Thanks for any help ...Bob
=IIf([tbGSTOptionsValue]=0,Null,[TaxLabel])
=DLookUp("TaxLabel","tblCompanyInfo")

Maybe:

=IIf(Not NewRecord,
IIf([tbGSTOptionsValue]=0,Null,DLookup("TaxLabel","tblCompanyInfo")), Null)

Note: DLookup without a criteria/criterion string will always return the
first matching record it finds in the table based on a natural sorting
order (like order of entry or by some field ending in something like ID,
key, code or num) that is potentially arbitrary. You should supply that
string if you know how to nail down the specific record you want.

James A. Fortune
(e-mail address removed)