Combo box trouble


A

Art Vandaley

Access 2007.

Hi Everybody,

I have a table with 10 fields. First combo box is enabling selection of
field lists of the table. I want second combo box to show data of related
field of th table according to the selection of first combo box. I try below
code:

If combo1.value="field1" then
combo2.rowsourcetype="Table/Query"
combo2.rowsource="table1" (I just want to have field1's data to be
shown by combo2)

else if combo1.value="field2" then
combo2...........
..
..
..
..
What should I do in order to get related field's data?
Help please. Regards.
 
Ad

Advertisements

D

Douglas J. Steele

No need to bother checking what the value is. Just use

Me.combo2.rowsourcetype = "Table/Query"
Me.combo2.rowsource = "SELECT DISTINCT [" & combo1.value & "] " & _
"FROM table1 ORDER BY 1"
 

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

Top