Multiple Forms

[Iamrickdeans]

Good Afternoon

After a few days of not hitting any problems with my build I am now again here to ask for help...

I have a master form lets call this 'client' and a subform which we will call 'orders' on each form is 'account number'

Each form updates a different table 'client' updates client and 'orders' updates the table 'orders'

The 'client' tables will allow the account number to exist only once where as the 'orders' table the 'account number' can appear multiple times.

What I am trying to work out is when I load the 'orders form' from within the 'client' form how I can have the 'orders' form pre populate the 'Account number' field with the active account number from the 'client form' and only display the records 'orders' associated with the specific client number within the active 'client' form. The reason that I want to achieve this is to minimise the chances of mis-keying information.

Any help as ever is massively appreciated.

Regards

Richard

 

[pbaldy]

In the properties of the subform control you'll see master/child links. If you used the subform wizard, it asks about linking fields.

 

[Iamrickdeans]

Thanks so much, was trying to do this manually this certainly helped! Been so many years since I used access to any degree... Have one further question is it possible to embed the subform onto a single tab on my 'client' master form as at the moment the linked subform is on every tab?

 

[pbaldy]

Sure, but it can be tricky. You have to select the tab first, then copy or place the subform on it.