Dialog Box Help

[Guest]

I am trying to create a dialog box to search by customer name, order date,
and as a third option, show total orders for the selected customer. I have
three list boxes that function well separately. I have heard that you can
stack these listboxes and by using an option group, make each one active as
selected. Does this make sense? Is there some way to use some of the built in
wizards to make this happen? I was hoping someone could give me some
direction.

 

[tina]

I have heard that you can

stack these listboxes and by using an option group, make each one active as
selected.

by "stacking", do you mean put all three controls in the same place, one on
top of another, so that you can see only one at a time? it's easy enough to
do this with an option group. let's say you have an option group control,
i'll call it grpChoose. the option buttons' values are 1, 2, and 3,
respectively. the listboxes are called List1, List2, and List3. you can set
the Visible property of the listbox controls on the Click event of the
option group with the following code, as

Me!List1.Visible = (Me!grpChoose = 1)
Me!List2.Visible = (Me!grpChoose = 2)
Me!List3.Visible = (Me!grpChoose = 3)

hth

 

[Guest]

Thank you, that's perfect.

by "stacking", do you mean put all three controls in the same place, one on
top of another, so that you can see only one at a time? it's easy enough to
do this with an option group. let's say you have an option group control,
i'll call it grpChoose. the option buttons' values are 1, 2, and 3,
respectively. the listboxes are called List1, List2, and List3. you can set
the Visible property of the listbox controls on the Click event of the
option group with the following code, as

Me!List1.Visible = (Me!grpChoose = 1)
Me!List2.Visible = (Me!grpChoose = 2)
Me!List3.Visible = (Me!grpChoose = 3)

hth

 

[tina]

you're welcome

Thank you, that's perfect.