Simple after dropdown update question

[gabriel_haro]

Hi: I have a little ms access 2007 DB with 4

filelds: Name, ID, License, State.

I have a Dropdown list where I choose the name, That works fine. I Can see the complete list of names after I click on the dropdown. Now,  after I pick one name, I need a field that shows the correct ID of the person chosen..

How difficult can that be?

thanks

[Former Community Member]

Its not as easy as you think ....

Here is a blog entry on that topic .....

http://forms.stefcameron.com/2006/09/29/selecting-specific-database-records/

Paul

[gabrielharodfdf]

thanks Paul, but, I just read the contents of the link you sent me, and this is not what I want. the link basically talks about showing records based on what you choose from the drop down.  ie: if USA, show California, Arizona, etc..  IF Mexico, show Baja, Sonora, etc..

I got two fields in my database:  Name & ID.

When I choose Name from the dropdown I want a separate READ ONLY field with the Correspoinding ID, or, maybe I need to SHOW BOTH the name & the ID in the same dropdown field.

is it possible?

[Former Community Member]

The link shows you the technique that is required .....you will have to execute a SQL statement to get the specific record indicated by the users selection in the dropdown.

paul