Link/Synchronize form to new form!!

  • Thread starter Thread starter Melissa
  • Start date Start date
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.
..
 
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.
 
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
 
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.
 
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?
 
Back
Top