Thanks guys I figured it out but I do have another question.
I need to create a Order Number which will be a unique number and I would like to mean something rather than some random #
So for instance the user opens the search form and using the list boxes provided they filter the data down to 10 records. The user then selects (checks a checkbox) 5 of those 10 records and that is what they want to order. Even though those 5 records are unique I need them to have the same order #. I don't think a simple autonumber field would work because it would create a unique number for each of those 5 records.
I was thinking about utilizing the data the user is selecting and maybe a date stamp. For instance each record would have the same 4 digit item number so maybe the order number would consist of item # and date. Sample would be xxxx01282020 where xxxx is the item number. However I feel I need something a little more unique at the end of xxxx01282020???? to make it truly unique.
Any suggestions?