S
sd2352
I recently built an employee database using one large table and multiple
forms. Each form has 3 common fields: SSN, Employee's first and last name. My
problem is when I enter a record into the first form, then click to the next
form, it doesn't stay on the same record. How can I get my forms to link
together so if I'm working on one specific employee record, it will stay on
that record when I switch to another form?
The forms I created include: General Info, ER Contacts, Benefits, Salary Hx,
and Termination. When I enter info into the General Info form then open the
ER Contacts form, I have to search again for the record I was just working
on, it doesn't automatically pull it up. Is there anyway to program Access to
pull up the SAME record in real time?
forms. Each form has 3 common fields: SSN, Employee's first and last name. My
problem is when I enter a record into the first form, then click to the next
form, it doesn't stay on the same record. How can I get my forms to link
together so if I'm working on one specific employee record, it will stay on
that record when I switch to another form?
The forms I created include: General Info, ER Contacts, Benefits, Salary Hx,
and Termination. When I enter info into the General Info form then open the
ER Contacts form, I have to search again for the record I was just working
on, it doesn't automatically pull it up. Is there anyway to program Access to
pull up the SAME record in real time?