Trouble with combo box

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...........
..
 

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 trouble 1
Combo box trouble 1
Combo box contents doesn't change when filtering combo box is chan 2
Criteria from Second Column of Combo 3
combo box data type 1
Using string variable 1
Creating a Search using a combo box and then creating a report. 4
Dynamic Naming of Form Button 3

Top