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

Using AutoNumbers

P: 9
I have a Table with an autonumber as the ID. I'm trying to get a form where i have a drop down box which displays all the ID values from the table and on selecting one of the values, i want the other fields in the form to get automatically filled by reading from the table.

But i'm not able to do this because i keep getting an error message saying that the auto number cannot be manually updated, which is not what i'm intending to do. Please help me out with this
Jun 4 '07 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,315
I have a Table with an autonumber as the ID. I'm trying to get a form where i have a drop down box which displays all the ID values from the table and on selecting one of the values, i want the other fields in the form to get automatically filled by reading from the table.

But i'm not able to do this because i keep getting an error message saying that the auto number cannot be manually updated, which is not what i'm intending to do. Please help me out with this
That's probably because the control source is set to the autonumber field. Get rid of the control source but keep the row source.
Jun 4 '07 #2

Post your reply

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