bobbybeers
Registered User.
- Local time
- Today, 05:07
- Joined
- Mar 14, 2013
- Messages
- 17
OK, I've read how to do this...really I have. I have a combobox value that I want to use which then based on the combobox value shows the value of another field for that respective record. Should be very simple - note, the recordset for the form is not the same table as I want to get the value for (which makes this harder apperently). I've tried ALL the different suggestions on here on how to do this - I do get a result but its not right....what am I missing??
=DLookUp("[PS2]","[02_PRESS_SCH]","[PS_DESC]"=[PS_COMBO])
PS2 is the field name, 02_PRESS_SCH is the table, PS_DESC is the field that I want to match with my combobox value.
=DLookUp("[PS2]","[02_PRESS_SCH]","[PS_DESC]"=[PS_COMBO])
PS2 is the field name, 02_PRESS_SCH is the table, PS_DESC is the field that I want to match with my combobox value.