HOW TO: Button to open different forms?

[Natan]

Hi guys,



I have a question for you,

I have 4 sub-categories, each of them has a form.
Also I have master category.

I made a form to my master category details, and a button to open a form by sub-category, that I chose on the master form.

I hope you understood me.

programing in english is
Open Form1 if CategoryName=1
Open Form2 if CategoryName=2
..
..


Thanks ahead.

[pbaldy]

If it fits that pattern:

Dim strFormName As String
strFormName = "Form" & CategoryName
DoCmd.OpenForm strFormName

[Natan]

Thanks.
But where I tell it to take the CategoryName from?

[pbaldy]

I don't know; how are you choosing it?

[Natan]

Combo Box, List...

[pbaldy]

You're really hanging on tight to the details, aren't you?

Try

strFormName = "Form" & Me.ComboName