My sentiments exactly!Hard to believe it magically started working....
Post 12 explains the solution(s), BTW, you cannot do it the way you have stated it.
Competent At Times
Windows 10 
Access 2013 64bit
My sentiments exactly!Hard to believe it magically started working....
Post 12 explains the solution(s), BTW, you cannot do it the way you have stated it.
Novice
Windows 10 Access 2016
Here is the query that it is currently using that works. As i said before, i believed it to be a problem with the cmbo itself, not the query.
ComboBox:
SELECT AssociateMasterT.EmployeeID, AssociateMasterT.EmployeeID
FROM AssociateMasterT
ORDER BY AssociateMasterT.EmployeeID;
Query criteria: [Forms]![CardCriteriaF]![employeeidCmBo]
i tried removing the "like" before and this didn't work - but now it does. The only other thing i did before it started working was manually re-wrote the query for the combobox, which i don't think actually mattered.
I appreciate the tip though, if i run into the issue again i'll add the .column(1) in.
DLookup - check if an ID matches the textbox it works, however if form is null it doesnt work.
Query Criteria - Reference Form Combo Box, Return Null
Posting Permissions
Reply With Quote