selecting from a combo and updating a text box

[RollerMan]

I have a database in access XP with two tables

one table
contains a locationID -autonumber
server-text
location-text

second table consist of maintenance information

id-autonumber
servername
location
errors
actiontaken
locationid

I created a form in design mode so that I could use a dropdown menu to select the server and have it automatically state what the location of the server is but it is not working. Any suggestions?? Those are the only fields I am concerned with.

 

[grnzbra]

What is the common field? When I've done that and had problems, it usually turned out that while the combo box was displaying the text from its recordset, what it was actually doing was supplying the value in the key field. If you want it to do a search on the text that appears use combox.text for the value to search.