Using AutoNumbers

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • confused99
    New Member
    • May 2007
    • 9

    Using AutoNumbers

    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
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    Originally posted by confused99
    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.

    Comment

    Working...