Showing an Autonumber in a Text Box

[nocolo]

I am trying to create a form that will be used to create work orders. There is a Work Order number that is assigned to each work order. Once filled out I will have a Save button. How can I include a text box on this form that will show the next available auto number from the work order number column from the work order table. Any help in this matter would be greatly appreciated.

chris (nocolo)

 

[Pat Hartman]

In a multi-user environment there is no way to display the next available number regardless of whether you are using an autonumber or generating your own.

If your form is bound and you are using autonumbers, Access will fill in the assigned number as soon as you start typing in the first field of the form. If you are using an unbound form, you can force Access to assign a number by programatically inserting a new record. However, since no data is available at this time, you should should probably also include a flag so you can later delete the record if the user never finishes the add for the new order. Using this method, your save button would do an update (since the record has already been added) rather than an insert.