Hi, i am trying to select get data to go into a field when the user
selects data from a dropdown. for example

Table 1:
Name Address
Joe Bloggs 1 No address

Table 2:
Name (Selected by dropdown) Address (I want the address
to appear when Joe is
selected)
Joe Bloggs ????????????

Does any 1 have any ideas. I have tried SQL and Queries but a cant
seem to get it to work, I would app. any help. THX

There are a couple of options, and really the one you choose depends
on your form, and what you are doing with it.

And easy way is to have the address visiable in an unbound textbox.
Then when the user selects the name, you do a DLOOKUP to find the
address and put it in the text box.

Another way is if the form that has the dropdown box is a tabular
form, then it will show.

You could have the drop down box have the names and the address
information be the subform and then just sinc them up.

E-Mail me directly if you need help figuring out which one to use.




leigh_kibbey (AT) hotmail (DOT) com (Badger) wrote in message news:<9aff4437.0309170904.4005315a (AT) posting (DOT) google.com>...

Take a look at Roger's Access Library at
http://www.rogersaccesslibrary.com/T...ntents2k.asp#C I have
found this site to be very beneficial as I fumble through working with
access.

The first item listed under the c's is CascadingComboBoxes2k.mdb (44
KB) ( beginner ) Access 2000 This sample illustrates how to restrict
the value of one combo box based on the value of another.

If that example doesn't help, then browse through the rest of the
examples. Chances are, if you're looking for something, it's in there
somewhere.