By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,080 Members | 1,268 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,080 IT Pros & Developers. It's quick & easy.

insert AutoNumber field in form

P: 1
Hello,

In the database attached, I have an order form that can add order items in a subform. Everything works fine but the end user has to enter the order id every time a new order is applied.
Please, can you help me set an autoNumber field that automates the Order id entries.

Thanks in advance,
Attached Files
File Type: zip Multiple Record Entry (2000).zip (86.0 KB, 69 views)
Jan 2 '12 #1
Share this Question
Share on Google+
1 Reply


Seth Schrock
Expert 2.5K+
P: 2,951
In the Orders table, just change the OrderID data type to be AutoNumber instead of Number. That is all it takes.
Jan 5 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.