Open Forms within a Form.. Help.

[simmoz]

Hi this is to be my first post of many I imagine, as I have been handed a task to design some user friendly forms for my colleagues.

I have a situation where I have created 2 forms
1 is to create an item type 1 and the second is to create item type 2

Now I have created a third Form which you can edit all the information relating to items no's 1 and 2.

What I have done is add a button to ADD the item should it not appear in the form. i.e. DoCmd.OpenForm "Item_type1"

But I would like this to ask the user.. are you trying to add Item type 1 OR Item type 2 ? and upon hitting the required button it will link them into the correct form.

Many thanks for any advice
Simmo

 

[Oldsoftboss]

Create a third form in the form. From there you can select which form to open.

Dave

 

[simmoz]

Thanks for the quick reply - very much appreciated!

cheers
Simmo

 

[BarryMK]

Create a third form in the form. From there you can select which form to open.

Dave

Cracking piece of code Dave. Now - could you rebuild my database?

 

[Oldsoftboss]

Could you rebuild my database?

Anything... for a price