Using a subform in an unbound form

[Chris Strug]

Hi,

Quick question,

Could someone give me an idea of the best approach to using an unbound form
in a subform?

For example, a customer order history, with the main form containing
customer details and the subform holding their order history (X) records.

I'm just wondering what the best approach is to setting this up?

I'm quite fluent in Access in general (if a little out of practice), and I'm
after concepts rather than specifics.

Any advice or suggestions are gratefully received.

Thanks

Chris Strug

 

[Allen Browne]

Why unbound?

A continuous form or datasheet contains a row for each record. If it's
unbound, you will have to create controls for each row you want and manage
(load/save) them yourself.

It would make more sense to me to use a subform bound to the Orders table,
with a main form bound to the Customers table. The subform would then
automatically display the order history for the customers (one per line),
based on the subform control's LinkMasterFields/LinkChildFields properties.

 

[Chris Strug]

Allen

Thanks for the reply.

I like using unbound forms for the flexibility. I'm not sure, I've just
never been very productive with bound forms unless its the simplest of
applications.

Is it possible to have an unbound main form linked to a bound subform?
Probably not I imagine.

I guess I'm just going to have to have a think....

Thanks again.

Chris.