Autopopulating a form field with table data

[Rick]

I'm sure that there must be a pretty simple solution to
this.
On an Access 97 form, when a user selects a Room Name from
a list box field, I would like the next field to
autopopulate with the matching Room Number. Both of these
fields are pulled from the same table of data. I just
don't know how exactly to set this up. Would I use the
SetValue macro action? I was trying to go by the examples
in the macro handbook, but I couldn't get far. I'm
assuming that this would be similar to having a form
automatically add a town/city after a user enters a
zipcode.
Any help on this would be great.

-Rick

 

[Ken Snell]

The code at this URL shows you how to do this with a combo box:

http://www.mvps.org/access/forms/frm0058.htm

You can use similar code setup with a listbox.