Form - subform question (1 Viewer)

[Peter Paul]

Greetings. I am creating a new form for use which has several parts to it. The subforms are needed to allow for multiple entry of items. On the one of the subform, I need to have a subform to allow for multiple choices. Access will not allow me to have a subform on a subform which is set for continuous forms. Any good thought on how to work around this?

I would like to keep the user on one seamless form for this, and this is the only sticking point.

Thanks yet again for your suggestions,
Peter Paul

 

[Rich]

How about a list box instead of a continuous form you can then add the relevant subforms, not exactly what you wanted but maybe of help.

 

[Pat Hartman]

You could put both subforms on the main form rather than nesting the second subform. Then when you scroll to a new record in the first subform, you would need to requery the second subform to keep it in sync.
1. In the Current event of the first subform-
Me.Parent![YourSubformName].Requery
2. Since you don't have the link master/child built in Access functionality with the second subform, you will have to populate the linking key field yourself in this subform's BeforeUpdate event-
Me.YourHiddenLinkingField = Me.Parent!LinkingField