Use combo to display record on subform?

[CW]

I am fine with using a combo to find a record on a form, and display all the
details about the chosen record in a number of controls.
But the very same design doesn't work if it is all on a subform on a tab
page. I can select the value in the combo (the name, for example) but the
address data doesn't pull through into the address controls.
How can I achieve this?
Many thanks
CW

 

[Steve Schapel]

CW,

But the very same design doesn't work ...

What "very same design" is that? Can you give a bit more detail about
what and how you are doing this please?

 

[CW]

Steve - thanks for picking up on this. Here's what I'm trying to do...
I have a main form (Main) based on a Jobs table that handles all aspects of
our packing and shipping services. I have 6 tabbed pages dealing with
specific parts of the process including quotes and transport and costs.
I need to be able to create invoices and record the revenue and have this
feed into the job-costing page.
I have a Debtors table with names and addresses of the regular customers and
an Invoices table.
I created a standalone Invoice form and used a combo based on the Debtor
table (DebtorName) to "Find a record on my form..." etc. Fine - this pulles
through the full address and customer number and everything needed to form
the top part of an invoice.
I then created a subform on a new tab page off the Main form and used this
existing form for it. But the combo no longer works - it doesn't do anything
except show the selected DebtorName. It doesn't pull through the details of
that debtor into any of the address controls.
By the way the link between the Main form and the Invoice form is on "Ref"
which is a field within both the Jobs table and the Debtor table and the
Invoices table.
I hope that's all the background info you will need to be able to advise me
where I'm going wrong, as this is a fairly critical part of our system that
we want to get up and running!!
Thanks a lot
CW

 

[Steve Schapel]

CW,

There are a number of possible approaches to the task of displaying
related data on a form. Some of these approaches are discussed in this
article http://accesstips.datamanagementsolutions.biz/lookup.htm

On the other hand, it could be something different again. Your form may
be using code to manipulate the RecordSource property. Or it may be
using the FindRecord method. Or it may be using the Bookmark property
to move to locate to a specific record.

So, sorry I was not clear in my earlier response. What we need to do
here is consider details such as what is the Record Source of the form
(now being used as a subform). And if the Record Source is a query,
what are the criteria. And what are the VBA procedures or macros that
are applicable to this process, possibly being applied on the from's
Current event, or the combobox's After Update event. Thanks.

 

[CW]

Steve -
Thanks for all that, and the article does look very useful.
Gratefully
CW