Populating combo box based on value of another from table

[Imbriani]

Hi all,

I have a table with two columns, CountyId and County name. I want to have a text box on a form into which is typed a county Id number and then have the Name of the county appear in another text box, both drawing from this table. As simple as this sounds, I have been unable to find my code for this and I haven't used Access for a while. Advice would be so appreciated.

 

[Remou]

You can use DlookUp in the second textbox.

[tt]=DlookUp("[County name]","County Table","CountyId=" & Me.Textbox1)[/tt]

Have you considered a combobox?

 

[Imbriani]

In this case, the user is used to doing it another way in a now-defunct front end. She would type in a code number, say 135 and in another field to be stored in the DB up would pop the name of the county, say "Wayne". It's just a way to make her job easier.