Subform to pull data from main form

[Guest]

I have a main form that holds general data about each customer. That has its
own table. Then there are several tabbed sub-forms hanging off this, each
containing various specific details. Each of these sub-forms has its own
table.
I want the customer name and ref to pull through from the main form onto
each sub-form so that you can always see which record you're in. (And maybe
some other data too, I'll see...)
How do I do this?

 

[Dirk Goldgar]

I have a main form that holds general data about each customer. That
has its own table. Then there are several tabbed sub-forms hanging
off this, each containing various specific details. Each of these
sub-forms has its own table.
I want the customer name and ref to pull through from the main form
onto each sub-form so that you can always see which record you're in.
(And maybe some other data too, I'll see...)
How do I do this?

Well ... you *could* do it by basing those subforms on queries that
include the Customers table as well as the related table for the
subform. BUT I wouldn't do it that way. I'd just move the controls
showing the customer name and ref (whatever that is) off of a tab page,
if that's where they are now, and onto the main form just above the tab
control. The user should then be able to see them no matter what tab
page is currently being viewed.