theinviter
Registered User.
- Local time
- Yesterday, 20:37
- Joined
- Aug 14, 2014
- Messages
- 240
HI guys ,
need help please,
i am designing a query for report and i am having field name drug name in query, where the user can enter drug name in the form so what i want is that;
to dlookup for the drug selected by user in Drug list (Table) to match the selected drug with 1- Drug name (text) and 2- chemo_drug (yes/No) and display only drug that match 2 criteria.
i tried this code
DLookUp("[drug name]","[drug list]","[drug name] ='" & [Drug name] & " AND [Chemo_drug]= " & "0" & "'")
but sow no record.
need help please,
i am designing a query for report and i am having field name drug name in query, where the user can enter drug name in the form so what i want is that;
to dlookup for the drug selected by user in Drug list (Table) to match the selected drug with 1- Drug name (text) and 2- chemo_drug (yes/No) and display only drug that match 2 criteria.
i tried this code
DLookUp("[drug name]","[drug list]","[drug name] ='" & [Drug name] & " AND [Chemo_drug]= " & "0" & "'")
but sow no record.