I have a table with values I wish to use for a combo box. I want to return all records with the combo box selections to my form using values from a different query.
I have a table with values I wish to use for a combo box. I want to return all records with the combo box selections to my form using values from a different query.
Does this help http://www.allenbrowne.com/ser-62.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
build a query for your combo box. assign it to the combo.rowsource.
the FORM is bound to a different query. the combobox is connected to a field on the form USING values from the combo .
Thank you all for your assistance. I solved my problem by combining the field value from my table to the values in the existing query
and defining the new query with a new name.