Control Source code

B

Bob V

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

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
 
J

James A. Fortune

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

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
[email protected]
 
Top