Subform with a multi-value field

[Birdman895]

Every time I mentioned multi-value fields I get the same input, don't use them. So I am trying to replace this field with a junction table. This will have multiple records for each record in the original subform. The only problem is that the original subform is set to continuous view and now I get the error that "you can't view a form as a continuous form if it contains a subform"
Any suggestions

 

[missinglinq]

You have to trick the Access Gnomes! The workaround I've been using successfully, for quite a while, for having a Subform when the Main Form is in Continuous View requires that you :

• Create your Main Form in Single Form View
• Place the Subform in the Header or the Footer, whichever you like
• Save the Form
• Now go into Properties and change the Form's Default View to Continuous View Form

Works, as my signature says, in 2003 and 2007.

Linq ;0)>

 

[Birdman895]

Well, the form your referring to as Main is actually a sub-form itself so this new one is a nested sub-form.
Also, I need this nested sub-form to repeat on each record of the subform.
I have attached a screen shot of it in pdf form.
In the first sub-form there is a control called Type. This is currently a multi-value field which is causing problems in a multi-user environment. I'm trying to replace it with a nested sub-form on the right side called ContactType(neste...).
Functionally I need to record multiple Type's, ContactType's, for each Note.
Thanks

 

[gemma-the-husky]

you can have a continous form with a sub form - but access wont do it for you automatically.

you have to do something like this. place both subforms inside a parent form. make the second subform dependent on a query that reads the current row off the first subform.

then in the current event for the first subform, you force the second subform to requery.

parent!secondsubform.requery

 

[Birdman895]

Thank you Gemma'. I am in process of applying your suggestion over the holiday. Will let you know