Link/Synchronize form to new form!!

M

Melissa

I have designed a database that utilizes pop-up forms
instead of a multitude of subforms. The main problem is
that the user will have to re-enter the primary key again
and again, for each pop-up form that is called forth,
which is related to the main form. After they create a
new record in the pop-up form, it is no problem to call
it up automatically again(using the where condition). It
is the rentry that has me worried. I hope that I am not
stuck and will not have to redesign this using subforms.
please help!!!!! If anyone knows the code to link a main
form and a pop-up, before the record is manually created,
let me know. I am desperate!!!.
Thank you.
..
 
A

Ashby

There are a few ways to handle this problem. One of the
simplist is to set the default value property of the
primary key on the popup form to:

Forms!MainFormName!PrimaryKey

The popup form will automatically capture the primary key
value from the main form for all new records. This method
requires that the main form remain open at all times.
 
M

Melissa

Thank you soooooo much!

So, I presume that this will create the new record
automatically?
This will hopefully eliminate wrongful data entry problems.

Thanks again, Melissa
 
A

Ashby

Melissa,

This will NOT create a new record automatically. It will
only populate the primary key for a new record. The user
still has to go to a new record on their own. Sorry for
the confusion.
 
M

Melissa

Yes, but if the pop-up is already filtered to call forth a
new record, then the autopopulation should fill in the
necessary fields (including the hidden autoid) and then
you can just save it as a new record- Right?
What I was asking is how to call forth a form whose record
in another table does not already exist and to link the
primary keys when creating a new record. Is this not the
way to do it?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top