Comboxes/Forms/Subform

[Ringers]

I am desiging my companys service database and have run into a couple of problems.

I have a main form that contains two combo boxes. Both combo boxes display the information that they are supposed to. But when i selection the data from the combo box it dosen't update the subform. I want the subform to update from the selection in the combo boxes.

Also i want the second combo box to filter it's display, depending on what selection is choosen in the first box.

Any help with problems would be great. Thanks.

 

[FoFa]

The filtered combobox, the second combobox's query will have to have a parameter the references the first combobox, and once a selection is made in the first combobox, the second one will have to be requeried for it to take effect.
If the combobox/s are on the subform, they should be bound to the underlaying form, or you will have to manually handle the update (bind the controls, it is easier). If they are on your main form, you will have to "push" the information to your subform to a control bound to the underlying table.

 

[Ringers]

The combo boxes are on the main form. How do i update the subform from them. They where originally text fields and i change them to combo boxes, so the don't update the subform anymore.

 

[Ringers]

I have attached a screen shot(zipped) of the database. As you can see the combo boxes are on the main form and there is a service report subform.

I want the subform to refresh depending on the selection made in the combo boxes. Also the Second combo box should limit it's selection(branch_city) from depending on the first combo box(branch_name).

Thanks.