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