Linking forms so appropriate record is selected when opening another form? (1 Viewer)

[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

 

[Dennisk]

Use the wizard to create a button on your main form to open another form and find a particular record.

or set up your own criteria. look up help on the OpenForm method of the DoCmd

 

[raggajunglist]

bingo!!
damn do i feel stoopid