Update more than one record.

[ramondrumon]

Combo box titles:

1001 Demolition
1001 1.1 Concrete demolition
1001 1.2 Wood Demolition

I have a combo box which will show [1001 Demolition only], if I Pick 1001 demolition it will update a list boxt to this:

1.1 Concrete demolition
1.2 Wood Demolition

This in turn is concatenated into a text box, then there are some questions to fill out on the form which apply to both 1.1 & 1.2. When I fill out the form I want both tables of 1.1 and 1.2 to be updated, but not 1001 Demolition. Can I do this or am I as clear as mud here?

 

[flugh]

I just did something similar with having 1 combo box based on another combo box. You seem to be in a very similar situation. The previous thread can be found at thread702-433303. I also found a lot of related threads by searching "synchronizing combo boxes" (also a section on that in Access' help file).

Good Luck

 

[ramondrumon]

I don't have a problem synchronizing combo boxes, if I choose multiple items in the list box (each is it's own record) I want the form to update all of the records with the same info from the form. I hope I am making some sense now.