Table driven field type display

[CarolynD]

Please forgive me if this has been asked and answered and I'm just not searching with the right language.

I'm creating a survey ... I have a QuestionTBL with a field called QuestType - that has a value of TEXT or SELECT.

On my form I have a cboResponse field that queries a table to get the information that needs to be in the drop-down depending on the question id ... I also have a txtResponse field that is a text field.

OnCurrent for the form I have this:

Select Case Me![QuestType]
Case "Text"
Me![txtResponse].Visible = True
Me![cboResponse].Visible = False
Case "Select"
Me![txtResponse].Visible = False
Me![cboResponse].Visible = True
End Select

This works ~ barely

The fields on the form switch inconsistently and act (yes actually act) confused.

Is there a better way to handle this?

Thanks in advance !

Carolyn

 

[Jack Cowley]

Try this:

Me![txtResponse].Visible = False
Me![cboResponse].Visible = False

Select Case Me![QuestType]
Case "Text"
Me![txtResponse].Visible = True
Case "Select"
Me![cboResponse].Visible = True
End Select

hth,
Jack

 

[CarolynD]

That worked !

Thank you !

 

[Jack Cowley]

You are welcome. Continued success with your project...

Jack