combo question

[Guest]

I want 2 combo boxes on a form. When I select an option in the first one, I
want only the linked info available in combo 2. Then comes the tricky part to
me anyway. I then want 4 text boxes to populate based on my combo 2
selection. I can get either to work but when I try and combine them, it's
doesn't work. I have info in each row source of each one which includes combo
box 2 as the row sourse for each. Can I combine the row sources? Please help

 

[Ken Snell [MVP]]

You should be able to do this by using these two articles from The ACCESS
Web.

This one ties the two combo boxes together:
http://www.mvps.org/access/forms/frm0028.htm


This one allows you to display columns from the combo boxes in textboxes:
http://www.mvps.org/access/forms/frm0058.htm