Can I use a macro to setvalues in a form with values from another form?

[betmck]

I have a form call [Calculate Gross Pay] which record source is a query call [Gross pay].
Also there is a form call [Payroll] which fields are bound to a table called [payroll].

There are several records on the form[Calculate Gross Pay] and I need all records to be stored in the fields on the form [Payroll].
When I run the macro to populate the records, only the first record is displayed on the [Payroll] form. How to repeat the macro until all records are copied?

This is the Macro I am using:
OpenQuery Gross Pay, Datasheet, Edit
OpenForm Calculate Gross Pay, Datasheet, ,,Edit, Normal
OpenForm Payroll, Datasheet, , , Edit, Normal


SetValue [Forms]![Payroll]![PCdate], [Forms]![Calculate Gross Pay]![PayRegDate]
SetValue [Forms]![Payroll]![PCEmp], [Forms]![Calculate Gross Pay]![PrEmpName]
SetValue [Forms]![Payroll]![ PCNISB], [Forms]![Calculate Gross Pay]![ nisb]
SetValue [Forms]![Payroll]![PCNISD], [Forms]![Calculate Gross Pay]![ NISD]
SetValue [Forms]![Payroll]![PCpaye], [Forms]![Calculate Gross Pay]![ PAYE]
GoToRecord Form, Calculate Gross Pay, Next,

[June7]

First, is PrEmpName actually employee name or an ID? Should be saving an ID not name.

Second, why is it necessary to save this data instead of just pull it in a query?

Third, looping in a macro is next to impossible. Use VBA and recordset or an INSERT SELECT query.

[betmck]

PrEmpName is employee name. I need to have year to date totals, so I thought saving the data would make it easier.

Thanks, I will try the INSERT SELECT query

[burrina]

You could store those values in a temp table and or clean out and refresh as needed. Just an idea. You can convert the macro to vba but it does not always work as intended.

Good Luck!

[June7]

What data are you trying to save? Each employees pay for entire pay period? Yes, certainly need to create records each pay period. INSERT SELECT to batch create records might accomplish.

Why do you Gross Pay query open?