Hey All;
I have a form with a ComboBox. I populate the ComboBox with the following query:
- SELECT [customers].[id], [customers].[name] FROM customers ORDER BY [customers].[name];
This query populates the comboBox with all the customer names from the customer table. I want to be able to select a customer from the comboBox and pass it as a parameter to another query, but what I keep getting is the customers.id from the customers table as an integer when I really want the customers name as text or a string. The other query use the table called "receipts" I want the criteria for the customer in the "receipts" table to match the comboBox in the form. I am currently doing this like this in the design view of the query, under criteria for "customers" in receipts table:
- =[Forms]![ReportBuilder_receiptsByCustomer]![ComboBox33]
This isn't working because I need the ComboBox to return the text value of the customer.name and not the integer value customer.id
How can I do this??
Thanks to all in advance