I have a form with 3 Combo Boxes (All with the same data in the drop-down menu):

Counseling_TypeP
Counseling_TypeS
Counseling_TypeT

Here's what I need done:
------------------------------------------------------------------------------------------


Temp = "What Counseling Type would you like (Primary, Secondary, Tertiary): "

If Temp = "Primary" Then
Type = Counseling_TypeP
Else If Temp = "Secondary" Then
Type = Counseling_TypeS
Else If Temp = "Tertiary" Then
Type = Counseling_TypeT
End If

Value = "What Counseling Type Value would you like (Self-Harm, Depression, etc.) "
----------------------------------------------------------------------------------------------
Can something similar be done in Microsoft Access in some form shape or way when I go to run the Query?

Thanks

--
Sincerely,
Brian McDonald