M
mattc66 via AccessMonster.com
Hi All,
I have a subform that contains 3 combo boxes.
cboBox1
cboBox2
cboBox3
cboBox2 and cboBox3 are set to visible = no.
Selecting the product type from cboBox1 determins which cboBox visible or not.
My problem is when I have already made my choice in cboBox1, I'd like the
corrisponding cboBox to remain visible for that record. What happens if I
move to the next record in the main form and go back cboBox2 or 3 don't show
regardless. I then have to select cboBox1 again for the correct cboBox. Yes I
know it's doing what I am telling it todo. What I need to know is where in
the properties would I place the code to keep the correct cboBox visible for
the selected record.
How would do this? I had put some code in the subform Got Focus, but that
doesn't do it.
Matt
I have a subform that contains 3 combo boxes.
cboBox1
cboBox2
cboBox3
cboBox2 and cboBox3 are set to visible = no.
Selecting the product type from cboBox1 determins which cboBox visible or not.
My problem is when I have already made my choice in cboBox1, I'd like the
corrisponding cboBox to remain visible for that record. What happens if I
move to the next record in the main form and go back cboBox2 or 3 don't show
regardless. I then have to select cboBox1 again for the correct cboBox. Yes I
know it's doing what I am telling it todo. What I need to know is where in
the properties would I place the code to keep the correct cboBox visible for
the selected record.
How would do this? I had put some code in the subform Got Focus, but that
doesn't do it.
Matt