Hi NeoPa & castusdata,
Thank you both for your assistance. I managed to resolve my Dlookup. It finally worked after several tries.
Appreciate your assistance.
User Profile
Collapse
-
Hi NeoPa,
Thanks for the guide. But i would like to display the respective Hazard Class when a particular Occupancy is selected.
Index only gives me the row number.
My Dlookup does not give me error, but its empty.
Please advise. Thanks.Leave a comment:
-
DLookup value from a combo box display results in text box
Hi,
I have a table called OccupancyT with following two fields - Occupation (text field) & Hazardclass (number field).
In my form, Occupation is shown as a combo box (called ComboOcc). I would like to display the Hazard Class code based on the selection of my combo box.
I tried this but no results was displayed:
=DLookUp("[Hazardclass]","[OccupancyT]","[Occupation]= '" & [Forms]![PropertyWorkshe et]![ComboOcc]...
No activity results to display
Show More
Leave a comment: