Re: linking databases

Kevin wrote:
Thanks for your reply! On one of the databases (the one I'm building,
the other was done by another person) I actually do updates with
forms. I've done this using a command button which uses a macro to
open a form which I further filter using an SQL statement. So if I'm
looking a record for say "Canada" i have command button which when
clicked on opens a form for "Canada" where editing of that record can
be done (I've locked the main form already so no editing can be done
there) I'm not very profficient with code though. Would you be able
to suggest code to me that I could use to update 2 or even more
databases using forms?

The simplest method would involve using the AfterUpdate event of your form
to execute an update query against the other table. That update could use
the record just saved to update the other table.


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com





.

Loading