murray83
Games Collector
- Local time
- Today, 09:04
- Joined
- Mar 31, 2017
- Messages
- 728
hi all
i have a sql query which pulls locations and the check string for each location but for quick check when people need to know the check string have put the query to combo box so this displays all the locations from the query
Then next to this i have placed a text box which i have placed the following in so far but it just screams #Name? at me
could someone much smarter than me point out what i have done wrong, ta
i have a sql query which pulls locations and the check string for each location but for quick check when people need to know the check string have put the query to combo box so this displays all the locations from the query
Then next to this i have placed a text box which i have placed the following in so far but it just screams #Name? at me
could someone much smarter than me point out what i have done wrong, ta
Code:
=DLookUp([Check_String],[Q_Check_Strings],[cmbLocation].[Value]=[Q_Check_Strings].[LOCATION_ID])