G
Graham
I have a MainTable with an associated Form on which i want to create at least
two, possibly three, or even four cascading combo boxes, to display a single
item on the form. I've created a separate Table2 for the three entries on the
first combo box and created an association between the two tables.(MainTable
& Table2)
Both MainTable & Form display the unique ID (Column 1) rather than the
actual data I want (Column 2) from Table2 ?
I've rechecked the association, and in Form/Control/Properties 'Control
Source', 'Row Source Type' & 'Row Source'.
Should my values from Table2 not now show in the combox on Form ?
I've created aseparate Table3 for around 15 values, only approx five of
which should show up in my second Combobox2, dependent upon the value
selected in Combobox1.
Is this the best way to set this up, and can I get Combobox1 working first
before trying to sort out Combobox2, or should the two be set up at the same
time?
I've found the various advice on this forum very confusing (different ways
of doing the same thing ?), particulary where to place the various "code"
suggested, if necessary ?
Can anyone advise if this can be done without the use of code, for Combobox1
& Combobox2 ?, and the simplest way of getting this to work ?
Many Thanks
two, possibly three, or even four cascading combo boxes, to display a single
item on the form. I've created a separate Table2 for the three entries on the
first combo box and created an association between the two tables.(MainTable
& Table2)
Both MainTable & Form display the unique ID (Column 1) rather than the
actual data I want (Column 2) from Table2 ?
I've rechecked the association, and in Form/Control/Properties 'Control
Source', 'Row Source Type' & 'Row Source'.
Should my values from Table2 not now show in the combox on Form ?
I've created aseparate Table3 for around 15 values, only approx five of
which should show up in my second Combobox2, dependent upon the value
selected in Combobox1.
Is this the best way to set this up, and can I get Combobox1 working first
before trying to sort out Combobox2, or should the two be set up at the same
time?
I've found the various advice on this forum very confusing (different ways
of doing the same thing ?), particulary where to place the various "code"
suggested, if necessary ?
Can anyone advise if this can be done without the use of code, for Combobox1
& Combobox2 ?, and the simplest way of getting this to work ?
Many Thanks