How to have uses click on the dropdown combo box or list box and have only sections of the form open, depending on the list or combo box item clicked.
Home > IT Answers > Development > How to have uses click on the dropdown combo ...
06
5 pts.
0
Q:
How to have uses click on the dropdown combo box or list box and have only sections of the form open, depending on the list or combo box item clicked.
Development, Database programming, ComboBox, ListBox
How to have uses click on the dropdown combo box or list box and have only sections of the form open, depending on the list or combo box item clicked.
ASKED: Apr 28 2008  4:33 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
BobBeechey
385 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Assuming that we are talking VBA in Access, you could do this:
Use the click event of the combo box to open the other form. The value property of the combo box will contain the number of the selected item clicked upon. You can then inspect this in this forms Open event to decide which controls to render invisible or read-only. Something like
Select Case Forms!Other_Form_Name!ComboBoxName.Value
   Case 1
      SomeControl.Visible = False
       SomeOtherControl.Enabled = False
   Case 2
and so on.
Hope this helps.
Bob
Last Answered: May 3 2008  3:41 AM GMT by BobBeechey   385 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0