Autolookup queries

[Brad@Zelle]

Please help. I am trying to creat an autolookup fields.
I have 2 tbls a Calls tbl and Callers tbl. I want to be
able to select a callers name from a drop down field, in
the calls form and would like the callers office, phone
number, and extention to auto fill in the Calls from. I
am having trouble wrapping my thoughts around this. Can
anyone help me design this.

 

[Ken Snell [MVP]]

See The ACCESS Web for how to use a textbox on a form to do this:
http://www.mvps.org/access/forms/frm0058.htm

 

[Brad@zelle]

Ken, so far so good. Thank you. Now for the next step. I
need the autolookup fields to refresh when I mover to a
new record. Also how do I get the autolookup values to be
stored in my main table so that they are related?

Thanks again

 

[Ken Snell [MVP]]

Not sure I'm following... your first post said the "refresh" should occur
when the user makes a selection from a combo box. What happens when the user
goes to a new record that is different? I'm also not sure about storing the
values in a main table (or at least what you want to do here)?

Please elaborate with more info about your setup and operations.