Hello,
I was wondering if someone could take a look at my problem as i as struggling to come up with a solution.
Is it possible to restricted the possible options available in a Combobox dependant on the value shown in a TextBox?
Eg:
A form called "frmmaster" has a Textbox called txt01, there is a subform on the form called "frmsub01" with a combo box called "cmb01" that has values taken from a table which are "1,2,3,4,5"
If the Textbox (txt01) had a value of "10" and i wanted people to only beable to select "1 or 2" from the Combobox (cmb01)on the Subform is this possible?
I understand this is simular to a cascading Comcobox but i have never used them on a subform before
Either way thankyou for taking the time to look at this problem
I was wondering if someone could take a look at my problem as i as struggling to come up with a solution.
Is it possible to restricted the possible options available in a Combobox dependant on the value shown in a TextBox?
Eg:
A form called "frmmaster" has a Textbox called txt01, there is a subform on the form called "frmsub01" with a combo box called "cmb01" that has values taken from a table which are "1,2,3,4,5"
If the Textbox (txt01) had a value of "10" and i wanted people to only beable to select "1 or 2" from the Combobox (cmb01)on the Subform is this possible?
I understand this is simular to a cascading Comcobox but i have never used them on a subform before
Either way thankyou for taking the time to look at this problem
Last edited: