Continuous Subform within a Continuous Form - Possible?

A

AR51NAL

Hi,

I have a number of records that I want to display within a continuous form
so I can see at a glance at what stage I am at with each of them. The
problem is that for each of these records there are various different actions
that I can be performing for them. I have therefore created a second table
with to hold these 'sub actions'.

I can use this second table to set a continuous subform within the main form
(in single form mode) but not within a continuous form as a warning box stops
me from doing this.

Thankyou for any help you can offer

I have created a query that joins the two table together and can display
this within a continous form but is very annoying as the same info from the
first table is naturally shown over and over again for each of the sub
actions.

Therefore my question is (eventually)

1. is it possible to set a continuous subform within a continuous form
2. Is is possible to 'group' records within a form (like in a report) so
that repeated info is only shown once as a header to the group
3. Is there any other simple (or ingenious) way of displaying the info in
the format that I want it.
 
A

Albert D. Kallal

You can make this work.

Build the two continues forms.

You then create a 3 form, and drop in the above 2 forms.

In the master form (which is now a subform), in the on current event, you
place the following command to make the child forms follow this form.

me.Parent.Child2.Requery.


In the link child/master settings for child 2 (2nd sub form) form you place

linkChildFields main_id (whatever is the name of the field in
this sub-form that is used to relate back to the parent table)
LinkMasterFields [MasterForm].[form].[ID] ("masterForm" is the name of
the control you used to hold the master form.

If you look at the following screen shots, take a look at the LAST one, this
is a classic "many" to "many" setup in which the left side has many donors,
and on the right side is the "splitting" of that donation into multiple
accounts. So, you can well display a many to many on a form. Here is
the screen shots (look at last one).

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm
 
S

Stefan Hoffmann

hi,
1. is it possible to set a continuous subform within a continuous form No.

2. Is is possible to 'group' records within a form (like in a report) so
that repeated info is only shown once as a header to the group
Yes, by an according record source.
3. Is there any other simple (or ingenious) way of displaying the info in
the format that I want it.
Yes:

Simply design your form/subform using a master-detail relation. Set the
DefaultView to datasheet for both.


mfG
--> stefan <--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top