Copying Records from one form to Another

[crisis2007]

I am looking for help on a problem I can not solve on my own. I have a form for data entry that opens up in continuous records. I want to populate the first few records on this form with existing records from another form called "template". This template form would hold names of employees and where he always works (two fields). So the new data entry form would copy the employee name and where he is working from the "template" form. I want the new form to open up and have the first five records populated with the five employees on the template form. The new records that follow would manually be entered. I'll gratefully take any assistance I can. I am a little familiar with vba.

 

[dhookom]

Forms do not hold any records. As a friend posted in another forum today

A form *displays* records but the records aren't contained in the form, any more than the Owyhee Mountains are contained in my office window.

If you want records from one table to be added to another table, you would use an append query (or possibly code).

Duane
Hook'D on Access
MS Access MVP

 

[crisis2007]

Ok - I should have been clearer -
I want the continuous form to populate with the first five records from another table. In essence, I want these records to default into the new form. The continuous form is tied to a different table.

 

[dhookom]

I believe the answer was in the last line of my reply.

Duane
Hook'D on Access
MS Access MVP