Combo Box help please

[Charlie]

I have a combo box with 4 fields which is using a query made from 2 related
tables. Column 0 populates the primary table and I need column 1 to populate
the secondary table once selected in the form. The details from each field
are located on the form (hidden with a visible field which joins columns 2&3
into one field)

Is there a way to do this? Really do not want to split this down if I can
help it. If I do need to split it, is there a way to select column 0 and it
make the 2nd combo box only show related entries e.g

Current Combo - 0=Company Name, 1=ContactID, 2=FirstName, 3=LastName

If Split:-
Combo 1 - 0=Company Name
Combo 2 - Only show contacts linked to Company Name

Many thanks in advance.

Charlotte

 

[Arvin Meyer [MVP]]

Start by looking at the listbox sample that does what you want:

http://www.accessmvp.com/Arvin/Combo.zip

 

[Charlie]

Hi Arvin,

Thank you for the file, however the combo boxes do not appear to be working
so I can not see what they have been populated with.

Charlotte

 

[Arvin Meyer [MVP]]

They are actually listboxes (which work the same as combos) and I just
downloaded and tested. And Yes they do work. I suspect you are blocking code
from running. Set your Macro Security to Low and allow all code to run.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access

 

[De Jager]

I have a combo box with 4 fields which is using a query made from 2 related
tables. Column 0 populates the primary table and I need column 1 to
populate
the secondary table once selected in the form. The details from each
field
are located on the form (hidden with a visible field which joins columns
2&3
into one field)

Is there a way to do this? Really do not want to split this down if I can
help it. If I do need to split it, is there a way to select column 0 and
it
make the 2nd combo box only show related entries e.g

Current Combo - 0=Company Name, 1=ContactID, 2=FirstName, 3=LastName

If Split:-
Combo 1 - 0=Company Name
Combo 2 - Only show contacts linked to Company Name

Many thanks in advance.

Charlotte