combobo0x-entering data to table

[tonysegerdahl]

I want to be able to add data to tables from a combobox by either
select allready exsisting data from the combo-dropdown list and also be
able to enter new data which will be added to both primary and
secondary table. Is that possible and how should I do that???

 

[TC]

Sorry, your questions, as currently phrased, really do not make much
sense.

What do you mean, to add data to a table by "selecting already existing
data"? If the data already exists, in what way would you need to "add"
it? What is the relationship between the "primary" and "secondary"
tables? We have no clue what is in those tables. How could we possibly
give you specific advice?

Here's my suggestion. Try to describe what you want to achieve, from an
"end user" perspective, in normal narrative English form. For example:
"A staff member needs to enter work orders. He needs to select the
customer for the work order in question. How should I code that?", and
so on. Then we can suggest how to do what you need.

HTH,
TC (MVP Access)
]http://tc2.atspace.com

 

[Guest]

What he was trying to say, was how to get data from "lookup table", I
think... . If this is a subject, create a table with one field of same type
like in second, linked table, Indexed ( Duplicates OK). In Lookup, set
Display Control to ComboBox , Row Source to Table/Query and Row source to
table, you want data from. Then try form wizard, put all fields from both
tables and compile. You should be able to get data from second table to first
table simply by selecting data from comboBox. Then play with property of
comboBox to get lookup display with mlticolumn etc...