Combo Boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using a combo box to 'Find a record on my form based on the value I
selected in my combo box' to filter off information to display in a
form/report. One of the Row Sources doesn't have a unique value but I need
the combo box to display unique values only for selection. The data is
company, catchment, wet well id (primary key). One company has many wells. Am
I going to have to normalise my data down again or can a combo box display
unique values only?
Many Thanks
 
Hi

In the SQL of record source of the combo box change the first line to
read "SELECT DISTINCT..."

If the combo box points directly to a table you may want to change
this to a query so that you can insert the above.

James
 

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

combo box filter 1
Changing the Selection Fields in a Combo Box 4
Combo box values based on the contents of another 9
Autofilling a form based on combo box selection 8
Blank combo or list box 1
combo box based on filter 8
Combo Box Help 7
Cascading Dependant combo boxes 0

Back
Top