I am using the GoToControl and FindRecord action. I suppose the idea is that I want Access to look at a particular field (Name) and search to match the selection from a combobox.
The problem is that, as a combobox source, I am using a Query. This Query Takes the person's Last, First, and Middle Name fields and formats them to one field so the Person's full name is shown in the box. On the Form, there are only LastName, FirstName, and MiddleName fields to search.
How can I get it to search the LastName and FirstName field when I am using data from my combobox which is not in the same format?
The problem is that, as a combobox source, I am using a Query. This Query Takes the person's Last, First, and Middle Name fields and formats them to one field so the Person's full name is shown in the box. On the Form, there are only LastName, FirstName, and MiddleName fields to search.
How can I get it to search the LastName and FirstName field when I am using data from my combobox which is not in the same format?