Sub forms which pop up when particular field is chosen on a form

[shapman]

Hi,

I have a main form 'contact details', with a subform from another table link as a one to many drop down datasheet. If i choose a particular subform from this (value 'y') I would like this to initiate another subform (from another one to many table) asking me to choose a particular group/value for 'y'.

in short: contact form > subform ='y' chosen > conditional pop up of second subform.

help, im not sure how to do this...

many thanks in advance.

 

[MStef]

Look at "DemoSubSubA2000.mdb" (attachment).
I think it can help you. Open "frmMain".

 

[shapman]

Look at "DemoSubSubA2000.mdb" (attachment).
I think it can help you. Open "frmMain".

thanks for this. Im still having trouble seeing how this can set a conditional pop-up for another sub form.

my first subform1 is a drop down list (linked in as a one to many table). I would like subform2 to pop up and request an entry when a certain value is selected in subform1. For example, subform one is a list of car manufacturers, if Ford is chosen, I would like another sub form to pop up which requires me to select which particular makes of Ford car from another drop down list.

This is a real puzzler for me

thanks again.

 

[neileg]

For example, subform one is a list of car manufacturers, if Ford is chosen, I would like another sub form to pop up which requires me to select which particular makes of Ford car from another drop down list.

This is really easy to implement using cascading combo boxes. There's no need to pop up a new form. Do a search in these forums for the subject.

 

[shapman]

This is really easy to implement using cascading combo boxes. There's no need to pop up a new form. Do a search in these forums for the subject.

I have looked through a number of the previous posting and am finding them difficult to digest - in terms of how these examples can be applied to my database.

Im not sure how this requery really helps???

Thanks in advance

 

[neileg]

Is this not what you want?