Windows 10 
Access 2016
Query displays something different than form
Hi,
I'm dealing with this weird issue in my Access database.
Basically I have a form with potential customers. I want to assign a sales representative who is responsible for this potential customer (his abbreviation).
For example:
Company 1 | assign Ja
Company 2 | assign Jo
Company 3 | assign Jo
etc.
My architecture is as follows:
tblEmployees: ID, Name, Abbreviation (for example Jack Miller | Ja)
tblPotentialCustomers: ID, Company, Employee Assigner (Ja, Jo...)
Then I have a Data Entry form for the Potential Customers... I have a combo box in there and I want to feed it employees from tblEmployees. This works fine by doing this:
SELECT tblEmployees.ID, tblEmployees.Abbreviation FROM tblEmployees;
This combo box has number if columns 2 and the bound column is 1.
I correctly see the abbreviations in the combo and it's correctly bound to respective employees.
When I select an employee for a particular customer, the value is correctly saved to tblPotentialCustomers.
Everything then goes through qryPotentialCustomers which also displays the abbreviation correctly.
Finally, this query then feeds the form where potential customers are displayed.
There is a text box to display the abbreviation for each potential customer, which is fed by the query value. But for some reason, this text box displayed the employee ID, not the abbreviation! (the bound value from the combo box above).
It displays its source as Employee from the query, where abbreviation is displayed.
I am totally confused here and would like your advice how to display the abbreviation.
Thank you :-)
Tomas
Reply With Quote
. Many thanks.
Originally Posted by Thomasso
