Comboxes/Forms/Subform

Ringers

Registered User.
Local time
Today, 15:32
Joined
Mar 4, 2003
Messages
54
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.
 
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.
 
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.
 
If the combobox is on the mainform, it should be populating a field in the table that the mainform is based on NOT the table the subform is based on. You seem to have a design issue here. Can you give us more info. One of the really nice things about relational databases is the ability to join tables in queries to obtain data rather than having to store it a gazillion times. As an example, you would not want the Customer's Bill To address to be stored for every order he places. You want the BillTo address to only be stored once. The ShipTo address needs to be stored with each order to support multiple shipto's but NOT the BillTo.
 
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.
 

Attachments

Users who are viewing this thread

Back
Top Bottom