table population

[Pammy]

I have a table and then a form built from the table, and on some of the forms
there are drop-downs that pull from other small tables, question, how do I
get the information filled in on the form to populate the table? On some of
the fields it is populating, on others it looks like the number from the
bound column, but I have changed this and it is still not showing the text.
I don't know what I have missed.
Thanks,

 

[Jerry Whittle]

You actually just want the numbers from the other table. It's most likely
from the primary key field in that table and uniquely identifies that record.

If you want to see this information in a report or query, you need to join
the tables on these linked fields.

 

[Larry Daugherty]

You can use comboboxes for many purposes. We don't know what you're
doing in any way. To get specific help you have to detail the issue
and describe what you're trying to achieve: the what, not the how.


The AfterUpdate Event of the combobox is where the action is. If your
combobox is selecting a value from a lookup table then you want to do
something with it. Sometimes just getting the information into the
combobox is sufficient. Your application might use the data there in
later manipulations. However, if your combobox returns several values
that you want in various controls on your form then you can do
something like the following. (In the AfterUpdate Event)

me!myTextBoxA = me!myCombobox1.column(1) 'col 1 is 2nd value
me!myTextBoxB = me!myCombobox1.column(2) 'col 2 is 3rd value

HTH