drop-down box/auto-fill in

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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?
 
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?
 
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.
 
Back
Top