I made you a little demo db (A2003)
Open form Table1Form and then click the label Macro1 and the entried will be made in Table2Form.
The way I have there are 2 spaces between each.
But you have to do some yourself
Go to Macro 1 in Design view. As you see the actions are being repeated but that is only satisfactory for a demo. You need to macros. The first gets things going with some actions and then has a RunMacro action. The RunMacro action basically repeats the step. When you select RunMacro action you will see you have a Repeat Count and a Repeat Expression.
The Repeat Count can be a number. But that is no good because you don't know how many records there will be. You can also enter an expression like =[Forms]![FormName]![TextBoxName]. TextboxName could be a count of the records.
But the more common way is Repeat Expression and is will be based on the records ending.
If you don't want the spaces then just delete the RunCode action lines.
Instead of F2 (twice) you can use
Public Function EndofField()
Forms![ProspectNotes]!ActdateComments.SetFocus
Forms![ProspectNotes]!ActdateComments.SelStart = Len(Forms![ProspectNotes]!ActdateComments.Text)
Forms![ProspectNotes]!ActdateComments.SelLength = 0
End Function
and call that with RunCode.
To go through your whole record set on the main form you SelectObject for the form and NextRecord at the end of the "inserting process" actions on the macro that is being run by the RunMacro action.
As I mentioned earlier you can't have any Null field for the Copy action so have your query eliminate any of those.
Hope that gets you going.
Open form Table1Form and then click the label Macro1 and the entried will be made in Table2Form.
The way I have there are 2 spaces between each.
But you have to do some yourself
Go to Macro 1 in Design view. As you see the actions are being repeated but that is only satisfactory for a demo. You need to macros. The first gets things going with some actions and then has a RunMacro action. The RunMacro action basically repeats the step. When you select RunMacro action you will see you have a Repeat Count and a Repeat Expression.
The Repeat Count can be a number. But that is no good because you don't know how many records there will be. You can also enter an expression like =[Forms]![FormName]![TextBoxName]. TextboxName could be a count of the records.
But the more common way is Repeat Expression and is will be based on the records ending.
If you don't want the spaces then just delete the RunCode action lines.
Instead of F2 (twice) you can use
Public Function EndofField()
Forms![ProspectNotes]!ActdateComments.SetFocus
Forms![ProspectNotes]!ActdateComments.SelStart = Len(Forms![ProspectNotes]!ActdateComments.Text)
Forms![ProspectNotes]!ActdateComments.SelLength = 0
End Function
and call that with RunCode.
To go through your whole record set on the main form you SelectObject for the form and NextRecord at the end of the "inserting process" actions on the macro that is being run by the RunMacro action.
As I mentioned earlier you can't have any Null field for the Copy action so have your query eliminate any of those.
Hope that gets you going.
