Viewing an Autonumber in Infopath

[kewpaloop]

I have a form linked to an access database. When the info in the form is
submitted, acess gives it a number with the autonumber. But in my case. I
need the person filling out the form to be able to view what number it is
assigning to his or her information they are entering, when they enter it.

Is it possible to get an autonumber before the submittion? Would i have to
take autonumber off in access and assign it through Infopath? Any help would
be appreciated.

Thanks
Kevin

 

[Art]

Not sure about Access but not possible in SQL

Even if you read the table and view the last number plus 1, someone else
could submit a form before you submit yours.