form within a form

[mcraven]

I have a field in the main form called COUNTRY. It is a pull down box and the user chooses a country. If he chooses LACA, another form with a pull down box appears so he can choose a country in that category. Problem is, that's where it ends. I need whatever he chooses in the second pull down to transfer into a field in the main form. HELP. I created the form, the query, and obviously only part of a macro.

 

[llkhoutx]

Forms!Form1!FieldName1 = Forms!Form2!FieldName2 on an appropriate event, as in FiledName2_AfterUpdate. Nulls may not be wanted, so you check for them before storing in Form1.

 

[mcraven]

llkhoutx

Where do I put that information? Event procedure - macro - on click - ????? Also - I discovered that when the person clicks on the Country box, the second form comes up before they choose the one that the form is suppposed to come up for - in other words, it comes up no matter what they choose. How do I get it so the second form only comes up when they make a certain selection in the pull down?

 

[llkhoutx]

Where do I put that information?

On the "fieldName2 AfterUpdate event.

I need whatever he chooses in the second pull down to transfer into a field in the main form. HELP.

On the second combo box AfterUpdate event,

Forms!YourMainFormName!YourMainFormField = Forms!YourSecondFormName!FieldName

This assumes that YourSecondForm is not a subform, but a form in and of itself.

If it's a subform of YourMainFormName, then

Forms!YourMainFormName!YourMainFormField = Forms!YourMainFormName!YourSecondFormName.form!FieldName