Hi all,
I am trying to use a DLookup to put a value in a txt box from a query on a different form.
The following works fine how ever I am trying to nest it with a "WHERE" the ChkBox Preferred = True which is on the same query
TxtCompanyType = DLookup("CompanyTypeName", "Query1", "CompanyId= " & CompanyID)
I want to add to this to the DLookup above Where my check box "Preferred" = True
I have tried to add this 9 ways to sunday and I keep getting end of statement errors????
Thanks
Dave