Carry Over Data in a Subform(SingleForm) within a Subform

R

rebecky

Ok. Starting New Thread.

I have a subform within a subform
for adding multiple Job Contacts(tblsitecontacts) for each Job
(tblJobOrderInfo). The parent subform is within a Main form containing
Employer Information(tblEmployerInformation).

Some jobs have more than one contact and some employers have more than one
job order. When the contact info is the exact same for each job order an
employer has, I would like to be able to copy or carry over the previous job
order contact information......

I tried both of these solutions,
http://www.mvps.org/access/forms/frm0012.htm, and
http://allenbrowne.com/ser-24.html. They work beautifully from one
record to the next in the ContactInfosubform. However, if the user goes to
enter a new job order in the PositionInformationsubform(SingleForm) the
ContactInfosubform(SingleForm) within the PositionInformationSubform stays
blank. For example: Joes Cafe has a job order for a waitress. This is the
position information in the subform within the Employer Information Main Form.

The contact info for this position is Joe Blow (phone, address, fax # etc.)
and goes in the ContactInfo subform within the PositionInformationSubform.
Joes Cafe is now posting an open position for Cook. The user clicks on the
add new position button in the PositionInformationSubform and adds the new
position information for Cook, but the contact info for the position of Cook
is exactly the same as the contact info for the job order Waitress and I
want that to automatically fill in within the ContactInfosubform.

Can that be done?

Thank you for your time
 

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