Hi
if i want to make a combobox
Type of calling : Personal, Question, Problem
i put them in a combobox whith a button GO
i want to open form 1 when i click Personal
Form 2 when i click Question
Form 3 when i click Problem
how can i do that ??
Hi
if i want to make a combobox
Type of calling : Personal, Question, Problem
i put them in a combobox whith a button GO
i want to open form 1 when i click Personal
Form 2 when i click Question
Form 3 when i click Problem
how can i do that ??
for example if I have a combo box say combo1:
Dim strFormName as string
if isnull(me.combo1) then
msgbox "Please Select a value"
Else
Select case Me.combo1
Case is = 1
strFormName="Form1"
Case is = 2
strFormName="Form2"
Case is =3
strFormName="Form3"
End SelectDoCmd.OpenForm strFormName
end if
Depending on the value selected in the combobox Form1 to Form3 will open
put the code in the after update event of the combobox.