How To Recieved A Unique Number From Access for an Infopath Contro

[JoeQ]

I am new to InfoPath and Access and not sure how to accomplish my issue. I
have designed a form for purchase orders and I need a unique number each time
a PO is filled out. My plan was to use Access to provide the form with the
PO number only. Basically when a user opens up the form Access needs to
provide the next available number for the form. Any help or ideas would be
helpful also my programing skills lack. Thanks in advance

 

[Paresh]

I am new to InfoPath and Access and not sure how to accomplish my issue.  I
have designed a form for purchase orders and I need a unique number each time
a PO is filled out.  My plan was to use Access to provide the form withthe
PO number only.  Basically when a user opens up the form Access needs to
provide the next available number for the form.  Any help or ideas would be
helpful also my programing skills lack.  Thanks in advance

I have not done this with Access but one way opf achieving this would
be to fetch the total number of records or highest primary key using
functions like count() or max() and then add 1 to it to get the next
number.

HTH.

Best Regards,
Paresh
http://www.openzeas.com/blogs/Paresh/default.aspx