relational database: how to make a related record automatically

[Moch]

I have the following problem.

I have two tables that are related. One tabel is contacts and the other is
projects.

Both tables are filled via a form. On the contacts-form i have a button "add
project". Then the project forms opens so i can fill in the data for this
specific project. But in the project form i always have to choose to wich
contact the projects belong.

Is there a way to make let the contatc be chosen automatically. In other
words: is it possible to make a button "add project" so that i can only add
projects for the specific contact i was working in?

Moch

[Bob Quintal]

"Moch" <mo**********@wanadoo.nl> wrote in
news:41**********************@news.wanadoo.nl:

I have the following problem.

I have two tables that are related. One tabel is contacts and
the other is projects.

Both tables are filled via a form. On the contacts-form i have
a button "add project". Then the project forms opens so i can
fill in the data for this specific project. But in the project
form i always have to choose to wich contact the projects
belong.

Is there a way to make let the contatc be chosen
automatically. In other words: is it possible to make a button
"add project" so that i can only add projects for the specific
contact i was working in?

Moch

In the code that opens your projects form, you need to put a
reference to the primary key of your contacts form. That is the
final parameter of the docmd.openform called openargs.

In the projects form you need to take that openargs parameter and
use it to preset the relevant textbox on the form.

--
Bob Quintal

PA is y I've altered my email address.