Combo Box Search (1 Viewer)
- Thread starter Emma35
- Start date
- Local time
- Today, 17:17
- Joined
- Feb 19, 2013
- Messages
- 16,606
the error message you get is quite clear - what do you not understand about it?
You are trying to find a record which matches on fullname, but your recordsource does not contain such a field. Names are risky fields to match on when looking for a specific record - what if you have two employees with the same name (it happens)
change your find to match on employeeID instead
You are trying to find a record which matches on fullname, but your recordsource does not contain such a field. Names are risky fields to match on when looking for a specific record - what if you have two employees with the same name (it happens)
change your find to match on employeeID instead
Thanks for having a look. I realise the error is telling me something straight forward but i still can't fix it. I changed the combo box to search by EmployeeID but am getting the error message attached. The RowSource for the combo is now
SELECT [qry_FullNames].[EmployeeID], [qry_FullNames].[FullName] FROM qry_FullNames ORDER BY [FullName];
SELECT [qry_FullNames].[EmployeeID], [qry_FullNames].[FullName] FROM qry_FullNames ORDER BY [FullName];
Attachments
-
Capture.PNG
Yes i've read both posts. I have the combo showing both EmployeeID and Name now. The error says data type mismatch. I know there's no field in the table called FullName, which is why the combo is looking at a query. Is this error something to do with syntax in the rowsource code ?
- Local time
- Today, 17:17
- Joined
- Feb 19, 2013
- Messages
- 16,606
compare the rowsource between your version and Tera's and also the code in the combo afterupdate event.
Also compare the bound column and column widths properties of the combo
the error you were getting was because you were trying to compare text with a number
Also compare the bound column and column widths properties of the combo
the error you were getting was because you were trying to compare text with a number
