Search results

I have a table where my values are based on. The table has two columns one for ID (Key ID) and on the other column the data. How can i display the value instead of the key ID. When i direct it to the field for the control source, it picks the ID and when i change it, it gives me a parameter...

Thank you for the Welcome... sure am glad to have found this place.

Paul and Larry... you both are awesome!!! Thank you!. The order totally missed my eye. Problem Resolved: Took out AS Expr1 and reordered the expression For future reference, this is the working code. SELECT Contacts.ID, Contacts.[First Name] & " " & Contacts.[Last Name] FROM Contacts...

Larry, First off, Thank you for the reply. I tried that but its giving me a syntax error ( see image below ). I have double checked the code, maybe i missed something, but as far as i know i didn't. It may just be something so small. On the Form, the code is in the rowsource of a combo...

Syntax error Help.... I have a form with a combo box that is valued based on a table (Contacts). The table has two four columns: ID, First Name, Last Name and DInteg ( Yes/No ). Trying to filter the values on the combo box to only display First Name and Last Name that has a DInteg value of...