Option boxes - Making items visible

[Chimp8471]

i want the user to make a selection from one of two option boxes, with the choice that they make i want a list box to appear straight away, depending on there selection, can anyone help please.

Cheers

Andy

 

[maxmangion]

you can use the visible property for your listbox

if me.listbox = true then
me.textboxname.visible = true
else
me.textboxname.visible = false
end if

 

[Mile-O]

Option Groups have values for each option. Check that you have the correct one and then

If Me.MyOptionGroup = 1 Then
    Me.MyListBox.Visiblle = True
Else
    Me.MyListBox.Visiblle = True
End If

 

[Chimp8471]

ok great i have that working, not sure if i should start a new thread for this now or just keep this one going ? (Please Advise)

i now need the user to make a coice from one of the visible list boxes, the trouble is i am not sure how this will work:

if you select the total time option the approprite box becomes visible...if you then highlight one of the choices... then choose the other option box and highlight one of the choices (the user may have changes their mind which report to run.

if you then select the first option box again the selection remains highlighted from the previous choice...

will this effect anything when running my query.

how do i program the form to run the chosen query ?

is there some useful code floating around to open my query or should i use a macro ?

i have attached my db for you to see...

i hope this makes sense

Please help me

 

[maxmangion]

in your code you can use the Else statement to set the visible back to false.

i.e.

if condition is true then
me.label.visible = true
else
me.label.visible = false
end if

the above should hide your label when your option becomes false (i.e. user selects another option)

 

[Chimp8471]

it is not the label that i am struggling with to be honest, it's the items in the list boxes..

 

[maxmangion]

did you try to Requery ?

 

[Chimp8471]

no to be honest, how should i do this please