drop-down box/auto-fill in

[Andre Grujovski]

Beginners question: I have a table with 3 columns in it. The first column is
unique (key), the next two columns are not unique. The table is named
TableXYZ. I want to insert a combo/list box (whatever will work) in my form
FormXYZ and select the unique item from a list corresponding to TableXYZ and
then (here's the tricky part) have the next 2 columns from TableXYZ be
automatically displayed on the form (either through a text box or whatever
will allow this to work). (Not just displayed, but actually part of the
form's table, does that make sense?)

I have tried a few different approaches, but I think I'm way off track.
Basically, I can get a combo box to display the table data, but when I select
it I really don't know how to link it (I'm pretty sure link is the wrong
word) to another part of the form.

Thank you in advance. Andre G.

 

[Duane Hookom]

Apparently you want to save multiple values from the lookup table into the
table bound to the form. Do you have a good reason for storing more than
just the key?

 

[Andre Grujovski]

I ended up figuring it out, I used a macro that did a DLookup() on an
UpdateEvent of the comboBox. But now I'm wondering why you ask me the
question. If the data isn't stored in the table bound to my form, then I
can't use it externally without the lookup table, correct? So that's sorta
why I wanted all the values stored in the bound table.

Is there a better way to do what I was asking, beside using a macro with
Dlookup?

 

[Duane Hookom]

I'm not sure why you can't use the data from the related table. What do you
mean by "externally"? Most external applications allow you to use SQL or a
query from an Access database. Maybe your needs are unique but you haven't
explained this.