Open form, fill in field

[sweyer]

I have a form that I created that is to add a new employee to our database.
We deal with insurance, so I want to be able to add a dependant to that
person's record. I have a form for new employee and a form for new dependent.
Once a person has filled in the new employee information, they should click
on a button that says add dependent. When the add dependent form opens, I
want the parent information to be automatically filled in.

For example, I have 2 tables: EmployeeInfo and DependentInfo. The
DependentInfo has a field called DependentOfSSN which is linked to the SSN
field in EmployeeInfo. When you add a new employee, you have to fill in SSN,
and when you go to the add dependent form, I want the field DependentOfSSN to
be automatically filled in with the SSN from the new employee screen.

Can anyone help me with this?

Thank you!

 

[Rick B]

one post per question please...

http://www.mvps.org/access/netiquette.htm.

 

[sweyer]

My Apologies....I was thinking that these were different forums with
different people using each and that someone may not see my question in the
first one, because they were surfing another forum. Sorry!

one post per question please...

http://www.mvps.org/access/netiquette.htm.

I have a form that I created that is to add a new employee to our database.
We deal with insurance, so I want to be able to add a dependant to that

[quoted text clipped - 16 lines]

Thank you!