Linking forms so appropriate record is selected when opening another form?

[raggajunglist]

Hi all,

I have a database with about 7 forms, from the main form i want to open an address/status updater.... however when i navigate from the main form to the updater the appropriate Account number and customer name are not pulled through as well, meaning i will be updating the address for the wrong customer..
Im pretty new to access so please bear with me if i havent given enough details etc, just let me know and i'll provide whatever is needed.
I realise i might be going about this the totally wrong way so if someone just feels like pointing me in the right direction that would be cool also

The idea is to have a main form from which i can navigate to an updating form and then others from that but i want to only be able to change/alter which customer is selected via the main form....

Any help is much appreciated

Thanks in advance..

Mikey

 

[MarkK]

If you open the child form using the DoCmd.OpenForm syntax you can specify a filter condition as a parameter. Check up on that in Access help if that's what you are doing.

You can also navigate to any record in any form if you know the ID of the field you want to make current using code like...

Forms("ChildForm").Recordset.FindFirst "ChildFormID = " & KnownID

You can also apply a filter to a form remotely like

With Forms("AddressForm")
  .Filter = "Province = 'BC'"
  .FilterOn = true
End With