Update a subform that has a continous form

[techkenny1]

Hi,
This one I have tried various methods to get to work. I understand that you cas not put a subform on a form when it is a continous form.
So how would I get data from the mainform to the subform that has a continous form?

Many thanks.

 

[kjv1611]

How about telling us the full picture of what you are trying to accomplish, so that we can be sure to help guide you in the right direction.

So far, I'm thinking you're wondering how to take some data from the main form, and either update an existing record or create a new record for the subform. What you most likely ought to do is to update the underlying record source (most likely a table) of the subform, and then the subform can be repainted or requeried, or recalced...

--

"If to err is human, then I must be some kind of human!" -Me

 

[MajP]

You can synch multiple continous subforms on a mainform. So you can have an unbound main form with a large continous subform (thus looking like a main form). Then underneath you can have another continous form. If you click on a record in subform one it will link to all the related records in the continous subform two.

 

[TheAceMan1]

How are ya techkenny1 . . .

[blue] ... I understand that you cas not put a subform on a form when it is a continous for ...[/blue]

Only if your using the form wizard!

Just be aware: with a continuous main form, you can't put a continuous subform in the detail area. [blue]It has to be the hearder or footer section of the mainform.[/blue] When you do so, access will apprise you of changing the mainform to single form. Pay it no mind and change it back to continuous!

[blue]Your Thoughts? . . .[/blue]


See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]