Minty
AWF VIP
- Local time
- Today, 09:33
- Joined
- Jul 26, 2013
- Messages
- 10,366
Hi All,
I'm trying to make a filtered search form using "*" as a wildcard default value in comboboxes, this works for all the text fields except for the account number field (Numeric primary key).
After quite a bit of reading up and searching, I tried using the following as the row source;
SELECT customers.ACCOUNT_NO, customers.CUSTOMER FROM customers; UNION SELECT "*", "All" From Customers;
But am still getting "#Error" in the combo box.
What am I missing? I have as usual been going round in circles trying different things to no avail...
I'm trying to make a filtered search form using "*" as a wildcard default value in comboboxes, this works for all the text fields except for the account number field (Numeric primary key).
After quite a bit of reading up and searching, I tried using the following as the row source;
SELECT customers.ACCOUNT_NO, customers.CUSTOMER FROM customers; UNION SELECT "*", "All" From Customers;
But am still getting "#Error" in the combo box.
What am I missing? I have as usual been going round in circles trying different things to no avail...