Combo box

[GR]

Hi,

I have a linked table listing Sales managers. A second
table listing Drives managers.
I need a combox which can be populated by both tables. and
if the person the user is typing in is not in the list
give the chance to the user to type in the new name and
ask if this new name should be added to the sales or
drives table (so the name is kept in sales or drives
tables and de combo is refreshed with the new name) the
design of the tables can't change, i mean, i've been asked
not to create a new table having sales and drives persons,
i've been ask to concatenate if possible both tables in
the combo. also this combo should allow multiple
selections..
any suggestions?? =/

 

[Arvin Meyer]

I believe you can have one or the other, but not both. You certainly can
concatenate entries from 2 tables, provided the have a common key. And you
can add a value to either table. You cannot add a value to a concatenation.
If you can populate the combo with *either* table (but not both at the same
time) then you can update the data in that table with a new record. Here's
how to add a new record using the NotInList event of a combo box:

http://support.microsoft.com/default.aspx?scid=kb;en-us;161007
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Marius Kavaliauskas]

Hi,

you can use union query as record source of combobox. And in NotInList event
you can let user to add new person

combobox doesn't support multiple selections - try to use list box, but
Listbox doesn't support NotInList event, so you will have to add button for
entry of new person

Marius

 

[Guest]

Great!! I really appreciate your help

-----Originalnachricht-----
Hi,

you can use union query as record source of combobox. And in NotInList event
you can let user to add new person

combobox doesn't support multiple selections - try to use list box, but
Listbox doesn't support NotInList event, so you will have to add button for
entry of new person

Marius




.