I am wondering if it is possible to create a field on a form that allows you to make multiple data entries and displays it back to the underlying table in its seperate field within a column. Basically, I want to enter data such as lets say #'s within a form:

# Name State
121212 Jon Ma
548754 Jon Ma
154545 Jon Ma

I want to enter Jon name and state once and when the form is submitted to apply itself to each of the # data entries in an organized manner on the table. Does this make sense? Can anyone help?

achiola

You could create a main form that contains the name and state information, then a subform for the number input. Then for the subform's before insert event code.
me!name=parent!name
me!state=parent!state