B
Brad
I'm having difficulty setting up a cascading combo box in my database. I have
a form that takes some input not related to my combo boxes, on the form there
is a subform (where the combo boxes reside). The subform is a datasheet, what
I would like to do is limit the possiblities the user can choose in the last
column based on the 3 fields prior. I have some understanding of how to do
this if the form actually had a combo box on it, what I'm not sure of is can
I program the datasheet to do the same? Any help would be very much
appreciated.
One suggestion i've come across is when the user selects the last cell to
"create" a combo box directly on top of the field that had the options and
when the user selects their option transfer it to the textbox neatly hidden
behind. Is this the only / best way?
a form that takes some input not related to my combo boxes, on the form there
is a subform (where the combo boxes reside). The subform is a datasheet, what
I would like to do is limit the possiblities the user can choose in the last
column based on the 3 fields prior. I have some understanding of how to do
this if the form actually had a combo box on it, what I'm not sure of is can
I program the datasheet to do the same? Any help would be very much
appreciated.
One suggestion i've come across is when the user selects the last cell to
"create" a combo box directly on top of the field that had the options and
when the user selects their option transfer it to the textbox neatly hidden
behind. Is this the only / best way?