Link to External Form

[Brian]

Hello,

I'm currently using Access 2003 and I'm wondering if
anyone knows how to link to an external access form?

I have DATABASE1.MDB and FORM1. From FORM1 in
DATABASE1.MDB I'm trying to link to FORM2 in
DATABASE2.mdb. Is this possible? If so how can it be
done? Thanks.

~Brian
([email protected])

 

[Roxie Aho]

-----Original Message-----
I'm currently using Access 2003 and I'm wondering if
anyone knows how to link to an external access form?

I have DATABASE1.MDB and FORM1. From FORM1 in
DATABASE1.MDB I'm trying to link to FORM2 in
DATABASE2.mdb. Is this possible? If so how can it be
done? Thanks.

~Brian
([email protected])
.

You can't link to a form in another database but you can
link to a table.

In your example, open DATABASE1.MDB. File-Get External
Data-Import and seclect DATABASE2.mdb. Select FORM2 (and
any querys that it's based on) and import those.

In DATABASE1.MDB, Go to File-Get External Data-Link
Tables. After choosing DATABASE2.mdb and select the table
(or tables) on which FORM2 is based.

You can now manipulate data in the table in DATABASE2 from
DATABASE1.

I'm not sure what you mean by link to FORM2 from FORM1.
Perhaps you could explain a bit and someone could help you.

Roxie Aho
roxiea at usinternet.com