Need to open a dynamic form......

[dalynching]

for edit from another form. I have a form with a drop-down box which you can select from existing order numbers. Once they select that order number, they should be able to select a form (which is dynamically created) in the second drop-down box. The problem I am running into is that I can't get the form to populate from the order number drop-down box. It opens the form, but the form is blank. Any ideas? Thanks.

Dalynching

 

[coco86]

I'm willing to take a stab at this but I may need more info

If I understand you correctly all you have to do is this:

DoCmd.OpenForm Forms!FormName.combobox2, , , "orderID = " & forms!formName.Combobox1

 

[dalynching]

Here's the scenario exactly:

On form Lookup_Mission I have 2 combo boxes: "mission" and "forms". I have the forms box pulling from a list of available forms and the mission box pulling a list of the missions that are in the system. I need to somehow populate any of the given forms with the data that I have for that form just from the mission # which in in the mission combo box on Lookup_mission. All the data that i need to retrieve is stored in the table "missionroster". Any further help would be great. Thanks!

Dalynching

 

[coco86]

Is the recordsource for your forms "missionroster"?

If so

DoCmd.OpenForm Forms!FormName.forms, , , "mission# = " & forms!formName.mission

Should do what you want