copy records next in order

[Erik P]

I have a table that has a bunch of fields, one field is called (ID) and in
this field the text is formatted in this manner EA-10000.The second field is
(initials). I would like to have a form with three text boxes on it where an
employee can enter the starting number and the ending number and another box
for there initials and it will add those records to the table. Any help would
be great. Thanks in advance

 

[John W. Vinson]

I have a table that has a bunch of fields, one field is called (ID) and in
this field the text is formatted in this manner EA-10000.

Is this a Text field containing the literal text string "EA-", or is it a
Number field with the prefix introduced by the format setting?

The second field is
(initials). I would like to have a form with three text boxes on it where an
employee can enter the starting number and the ending number and another box
for there initials and it will add those records to the table. Any help would
be great. Thanks in advance

What do you mean by "those numbers"? Where do the initials go? Are you trying
to create a bunch of empty "placeholder" records with different ID's? If so...
that's very rarely a good idea; new records should be created (usually on a
form or subform) at the time that you have data to be put into them. More
details please!

 

[Erik P]

This is a text box with the literal text "EA-" in it.

 

[John W. Vinson]

This is a text box with the literal text "EA-" in it.

I'm sorry, this is making no sense. A text box is a display tool on a form.
It's not a table field, and its data isn't stored anywhere. Are you talking
about a Table? What's the context?