When I click OK on my form, I want a new form to open up and ask for more information. The new form has a comboBox and a sub-form with another comboBox.
This makes 2 problems:[ol][li]What is the syntax for calling my 'frm_DataSetCompany'[/li][li]I don't think I got the syntax right for capturing data from my sub-form:
what is the correct code?[/li][/ol]
Alan
This makes 2 problems:[ol][li]What is the syntax for calling my 'frm_DataSetCompany'[/li][li]I don't think I got the syntax right for capturing data from my sub-form:
Code:
DSN = frm_DataSetCompany.frm_Subform_DataSets.cboDSN.Value
Alan