Solved: Form/Subform Question

[jauner]

I have a form that has several subforms related to it. When creating new records the link is an account number that has to be picked from the main form. What is the best way to handle to make sure when new records are created that the account number field on the subforms gets filled the OnCurrent Event?

I also want to make sure that the combo box containing viable account numbers is required to pick when clicking on the subform.

Please help.

[geekgirlau]

You can set the default value for the account number to the field in the parent form, and also do a check in the BeforeUpdate event in the subform so that if the account number if null, populate it with the value in the parent form.