display order number

[Hopeless]

I'm very new at using Access.



I’m trying to make a database in which people can place orders.
I made a form to tell the costumer their order number after submission;
but the when tested it all ways displays the order number as 1.
I’d like it to display the newest order number from the datasheet. Please help

[Hopeless]

one more thing:
this database is linked to sharepoint

[orange]

I don't use Sharepoint, however, to get focused responses, you should tell the readers about your data base and the Tables and Relationships.
You haven't given much info in your post.

[Missinglinq]

In particular

• How are you generating the Order Number?
• How are you retrieving the Order Number to present it to the customer?
• Is the Order Number defined as Text or Number?

Linq ;0)>