Auto Number mysql

I have just moved over to mysql as the back end and keeping access as
front end. My database is for a ordering system. I use autonumber as
the Order Number. as mysql does not display the order number
(autonumber) until the form has been saved.
Is there a way on the order form that i can have a button that will
save the data then reopen the form so the order number ( autonumber is
displayed)
I am currently only learning about access so some nice easy instruction
would be very helpful
Thanks
SimonUm, this isn't a mysql newsgroup. It's a SQL Server newsgroup. They are
different products.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
<S.Dickson@.shos.co.uk> wrote in message
news:1162900496.357948.305300@.b28g2000cwb.googlegroups.com...
I have just moved over to mysql as the back end and keeping access as
front end. My database is for a ordering system. I use autonumber as
the Order Number. as mysql does not display the order number
(autonumber) until the form has been saved.
Is there a way on the order form that i can have a button that will
save the data then reopen the form so the order number ( autonumber is
displayed)
I am currently only learning about access so some nice easy instruction
would be very helpful
Thanks
Simon