Placing a subform on a continuous form, Hopeless?

[Rudy Pry]

I thought I would tag this group real quick (before I spend days, possibly
weeks and thousands of lives) to see if anyone knew of a work around to the
MS Access limitation of not being able to display a subform on a continuous
form. I believe the issue stems for the inability of access to 'show' the
form in more than one instance.
Basically, what I'm looking for is a grouping of the 'client' and then a
subform in the detail area to list the 'orders' on my search results screen
but then to also have that in a list or continuous format. This is easy
enough in a report or static form but on a continuous form access wants to
whine and bitch about it. Much like I'm doing right now. My boss wants to
see one client name not a series of the same client name for multiple
'orders'. If you know of anything or can point me in the right direction
please let me know.
Thanks,

R


Rudy Pry

GTU

(e-mail address removed)

 

[Marshall Barton]

I thought I would tag this group real quick (before I spend days, possibly
weeks and thousands of lives) to see if anyone knew of a work around to the
MS Access limitation of not being able to display a subform on a continuous
form. I believe the issue stems for the inability of access to 'show' the
form in more than one instance.
Basically, what I'm looking for is a grouping of the 'client' and then a
subform in the detail area to list the 'orders' on my search results screen
but then to also have that in a list or continuous format. This is easy
enough in a report or static form but on a continuous form access wants to
whine and bitch about it. Much like I'm doing right now. My boss wants to
see one client name not a series of the same client name for multiple
'orders'. If you know of anything or can point me in the right direction
please let me know.

The usual way to deal with this is to use an unbound main
form with the continuous form as a subform. Then add the
orders form as another subform on the main form. Set the
orders subform's Link Master/Child properties so that it
displays the orders for the current record in the customers
subform.

You can set the Link Master property to a text box (on the
main form) that has an expression like:
=customersubform.Form.customerIDtextbox

 

[Rudy Pry]

Oh Yea Babe!!! pure absolute (insert explitive here) genius!! I have not
finished it but understand completely on how/what i need to do. I just
needed someone to turn the lights on so i wouldn't trip over it in the dark.

Many many thanks!

Rudy Pry

GTU

(e-mail address removed)

 

[Albert D. Kallal]

I would re-consider the interface.

You can get a nice drill down.

Take a look at the following screen shots:

http://www.attcanada.net/~kallal.msn/Articles/Grid.htm

 

[Rudy Pry]

Very Nice!! Now that's thinking a little different. opened my mind to a half
million things. I appreciate you sharing your knowledge!!

Rudy