Trouble with combo box

  • Thread starter Thread starter Art Vandaley
  • Start date Start date
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...........
..
 
Back
Top