An example: searching for a car.
[check_box_make] 'makes the next three boxes visible when checked
[check_box_Chrysler]
[check_box_Lexus]
[check_box_Subaru]
[check_box_seats] 'makes the next 4 boxes visible when checked
[check_box_2]
[check_box_4]
[check_box_5]
[check_box_7]
The goal is to shift the seats check boxes down a specified distance if [check_box_make] is checked. The purpose of this is in my actual form I have so many fields that the user would have to scroll through a bunch of them to get at the categories he/she wants to use.
When I try to set the Format -> "Top" property in VBA, it moves the object to the top of the form (.0007"). My code looks like this:
Expand|Select|Wrap|Line Numbers
- Dim startpoint as int
- startpoint = .4
- If [Forms]![frmFrontEnd]![check1].Value <> Yes Then
- [Forms]![frmFrontEnd]![check1].Top = startpoint + 0.5
- End If
(PS: the reason I'm not just using combo boxes is because the user will often need to use multiple values in each category.)