Combo Box / Option Visible if Record type is 1 or 0

[nrugado]

Hello all thanks for looking at this...

I want to generate a list of questions that will be answered in a form and be given a value if the user selects from the combo box or the options box. However, I do not want both the combo and the options box to be *Visible*. I want the control to match the type of question.

I was thinking that I would assign each question a question type that the control could look at to see if it should be visible.

i.e. question type =1 then show the Y/N option box or question type =0 then show the combo box. This would be in continious view so the questions would be on one form.

Can anyone help with the visible part of the coding....

Thanks in advance for any assistance that you can provide.

Nick

 

[MooGuru]

If you've already set some variable up to hold the type (0 or 1), then something along the lines of (I can't remember syntax offhand)...

if variablename = 1 then
comboname.visible = true
else
optionname.visible = true
end if

 

[MooGuru]

I forgot to add, for the above, you should set the properties of comboname and optionname to be Visible, No.

Or add,

optionname.visible = false and comboname.visible = false to the respective parts when u want them to disappear.