Auto add data in form

[Tawni]

I have created a form based on a set of records queried by a field, Serial #.
Using a form, I need to add an order # for each serial #. I will use the
same order # for the set of queried serial #'s. I would like to type in the
first order # and then have it automatically populate the remaining records.

How would I do this?

 

[NTC]

do you have a set of multiple serial #s all together; as a result of the query

or - are you getting one serial# at a time via the query ??

the answer depends on which way

 

[Tawni]

Each serial # is a record in the table, so I guess you could say one serial #
at a time. I am querying a range, for instance between 2000 and 2100. In
this case, the query result would list 100 serial #'s or 100 records. Does
this help?
I then would need to add the same order number to each one of these. The
result would look like this:

Serial # Order #
2000 15852
2001 15852
2002 15852 (and so on)

Thanks for your help.