How to go directly to a record in a subform

[Brian]

I have created 2 forms in Access 2003. The main form contains data that is
mainly product details such as order numbers, product descriptions etc. The
main form also has the name of the supplier, the original equipment
manufacturer and the transporter. The sub-form contains the contact details
for the supplier etc.
How do I get directly from a record in the main form indicating supplier X
to the sub form record with the details of supplier X. You might guess I'm
quite new to using Access, I've used Excel for linking data sets in the past.

 

[roccogrand]

I am really sorry Brian, I drafted a really good reply to your question
yesterday and the server was overloaded and the message was lost. I will
check back Saturday. Hope you are still interested then.

LDN

 

[Brian]

Thanks, I'm grateful for any response

I am really sorry Brian, I drafted a really good reply to your question
yesterday and the server was overloaded and the message was lost. I will
check back Saturday. Hope you are still interested then.

LDN

 

[BruceM]

I will assume that when you say "the main form contains" you are referring
to a table on which the main form is based; likewise for the subform. If
so, there is quite a variety of entities (orders, products, suppliers) in
the main table. Supplier information, on the other hand, is part of the
supplier record, so it is not clear why the supplier information is split
between the main form and a subform. A table should contain information
about a single entity (order, product, supplier). Some description of your
database structure, including relationships, would help.
That being said, the short answer to your question is that if there is a
proper relationship between the main form's record source and the subform's
record source, navigating to the main form record will display related
information in the subform. One of the things you need to check is the Link
Parent and Link Child properties of the subform control. In form design
view, click the very edge of the subform so that it is selected, then click
View > Properties. If there is nothing in the Link Parent and Link Child
property, click into the row and click the three dots. Access may try to
suggest something. If not, choose the linking field (maybe your SupplierID
field, but it is impossible to say without more information.