Linking two Forms

A

Andrey

Hi, Briefly I would like, with a single click using/on a control button, to
be able to move between two forms. Easy so far, here's the tricky bit - I
would like to keep/retain the details of the same record as I move between
the forms. Both forms are based mainly on two tables which both have their
own subforms and linked minor tables. These two tables are linked on a
one-to-one relationship on a unique Id field.

Help would be much appreciated. Thanks.
 
A

Andrey

Thanks Arvin that worked fine. I had to create a new command button to figure
out what was happening with the 'event procedure' but Access's wizard makes
it rather simple to make things happen without me having to understand what's
going on behing the scenes. Didn't realise there was a second option that
filtered on specific records.
 
A

Andrey

This part would be nice to know, but isn't required for now:
{I would like to the achieve the above using a macro, as all my command
buttons are linked to marcos but perhaps there is no need for me to go done
that route. Is there any added benefit from using either macros as opposed to
'event procedures'? If someone has the time please reply}.

I would next like to copy the unique id to the 'second form' thereby
creating a new linked record, after having created a new record in the 'first
form'. Again any help would be appreciated. (My knowledge of Visual Basic is
non-existent so any help of where to incorporate any lines of script would
also be useful).
Cheers.
 
Top