G
Guest
I have a combobox on a form that when an item is clicked on, it opens up the
record that corresponds with that chosen criteria which works fine. The
problem I am having is that when the combobox is activated instead of names
it has numbers however, when I view the records from the row source in the
SQL statement:Query builder window it lists the names as I would like to see
them. Any help would be apreciated.
Here is the SQL statement that I am using:
SELECT [Trade Form].ID, [Trade Form].[Request Date], [Trade Form].[Trade
Requested By], [Trade Form].[Trade Accepted By]
FROM [Trade Form];
The [trade requested by] and [trade accepted by] are comboboxes on the form
that use the records from tblpersonnel.
Thanks
Mark
record that corresponds with that chosen criteria which works fine. The
problem I am having is that when the combobox is activated instead of names
it has numbers however, when I view the records from the row source in the
SQL statement:Query builder window it lists the names as I would like to see
them. Any help would be apreciated.
Here is the SQL statement that I am using:
SELECT [Trade Form].ID, [Trade Form].[Request Date], [Trade Form].[Trade
Requested By], [Trade Form].[Trade Accepted By]
FROM [Trade Form];
The [trade requested by] and [trade accepted by] are comboboxes on the form
that use the records from tblpersonnel.
Thanks
Mark