need query to filter combobox row source list by table records

M

Max Moor

Hi All,
I hope my subject line made sense. I'd like to specify a list for the
rowsource of a combobox, but I want the list to omit items that have already
been used in a the underlying table.

The values ID phone numbers, and are "Home", "Work 1", "Work 2", "Fax",
"Mobile", and Pager". The underlying table has a record for each existing
number with the person's ID code, the label, and the phone number. When new
numbers are added, the user gets one of the listed labels from a combobox. I
want it to display only ones not yet used.

Is there a way to do this with a query in the combobox's rowsource?

Thanks,
Max
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combobox filtering 2
Append Query - key violation - no duplicates, records exist in par 4
Query Combobox Problems 2
Select certain items in query 1
Unable to display values in ComboBox using SQL query from table 1
Lookup current record with ComboBox, any changes create new record 3
nested select/union select without referenced table 7
Filtering a table by using criteria in another table 1

Top