bounding a subform to a combo box

[madrav72]

hi

im trying to create a form that has something of the following structure

the main parent form has customer details which is straight forward

the main form also has a combo box which contains the name of a supplier

the first subform has supplier details so that when i click on the above combo and select a supplier their details come up in here.

now i also have a second subform on the main form which tells me the orders that this customer will make this shows me all the orders the customer made relevent to the above suppliers products

i know the above sounds like a strange implementation - i dont know if its been done already but i was hoping someone could point me the right direction for a correct implementation to do this.

many thanks

 

[gromit]

hi -

Should be achievable. I would use the AfterUpdate event of the combo box to modify the recordsource of the subform. You modify the SQL statement for the recordsource depending on the selections.

Note: I seem to recall that this doesn't work if you have a parent/child relationship established between the forms. So it is better to delete the subform from the form and recreate it without the parent/child relationship.

Let me know if you still have questions.

- g