2 combo boxes on form

[Guest]

i have 2 combo boxes on my form, both combo boxes draw data from the same
colum in a table.
when i update one combo box the other combo box displays the same data that
i updated.
how can i make the combo boxes display different data from the same colum in
the table?
thank you.

 

[Guest]

im sorry jeff, im new to this and i have trouble explaining...thank you for
being patient

-the fields in the table that is the forms record source is a list of names
in a column,
(in my table i have names listed in a single column)

-on my form i have 2 combo boxes labeled "name"

-when using my form i update combo box #1 with the name "joe"
then i update combo box #2 with the name "fred"
combo box #1 instantly changes to "fred" and i want it to remain "joe"

i hope i explained it right
thank you
gary

 

[Jeff Boyce]

Gary

"different data from the same column"?

I'm not understanding what it is you want to accomplish. A literal
interpretation of that phrase would mean "data from some other row". Which
row? How many rows are there in the table?

Everything starts with the data in Access. How about if you post back with
an example of the data you are using?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Jeff Boyce]

Gary

You've explained what you are doing.

Now, why? What will having two combo boxes, both looking at the same field,
allow you to do?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/