Re: Auto-Poulate a Value in a Table

Again, you are describing "how" ("I click... brings me to ...").

Re-read my suggestion about using a main form/sub-form construction. Access
will take care of copying the main form's primary key value into the
sub-form's foreign key.

While it is possible to do what you are describing, exactly as you are
describing, it is most certainly harder than the above method. After all,
you can drive nails with a chain saw, but it isn't necessarily a good use of
the tool...<g>

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Kerensky18" <Kerensky18@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B003EF0B-2650-4174-BFA8-465D5FBF5759@xxxxxxxxxxxxxxxx
I will try to clarify further... I want the policy number to transfer to
the
new record instead of the records policy number being the default NULL.

For instance the policy number is 5, I click add additional insured
button,
brings me to a blank form to update the table but with the policy field
already having the value of 5.

"Jeff Boyce" wrote:

It sounds like you are saying you want an empty (?dummy?) record created
in
table2 when you create a new record in table1. Why?

In Access, you typically would not need or want to create a new record in
any table until you had data to put in it.

Also, in Access, you would typically handle creating one/more related
records in a "child" table (your [AdditionalInsured]) by using a main
form
(displays the [Policy] info)/sub-form (displays any/all
[AdditionalInsured]
info) construction. This way, Access would handle adding the necessary
[PolicyID] to the child table, but only when you need to add a record.

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

"Kerensky18" <Kerensky18@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1ED74D8B-4503-4BF5-9065-F177E76DEAB3@xxxxxxxxxxxxxxxx
Hello Again;

I have another issue that I can't figure out. I'm designing a Insurance
database for class and am having issues with two tables.

The two tables are Policy and Additional Insured.

Policy is tied to Additional insured via policy ID.

What I would like to happen is the user clicks on a button in
Policy(form)
called Add Additional Insured. I want this button to open up the
Additional
Insured(form) to a blank record and auto-populate the Policy ID #. Is
it
possible to do this?





.