Form with subform and search combobox in main form: subform does not update accordingly

[FL0XN0X]

Hi,

I have got a form with subform. In the main form, I have added a combobox using the 'Control Wizard' to have a combobox to search for records.
When I search for records using the combobox, the records in the main form are shown, but the subform is not updated accordingly.

- Relationships are 'OK'
- Link Master Fields / Link Child Fields are 'OK'

What's the clue to have the subform showing the records that are linked to the record that is shown in the main form as a result of a search using the combobox.
Thank you in advance.
Kind regards,
Bart

[RuralGuy]

I question this statement:

- Link Master Fields / Link Child Fields are 'OK'

[FL0XN0X]

Hi RuralGuy, thank you for your quick response

It concerns two tables:

Customer:

ID	Customer
1	Jack
2	John
3	Els
4	Nick
...

Weekprofile

Id	Customer_Id	WeekprofileName
1	1
2	1
3	2
4	3
5	3
...

1 customer can have many Weekprofiles. The Customer_Id in the Weekprofile table is filled by using the lookup tab in the table design.

Main form is based on Customer table, the subform is based on the Weekprofile table In order to make this clear to me, can you guide me step-by-step, please? Relationship: 1 customer can have many weekprofiles, I have have a relationship of 1-many between the two tables (ID from Customer table is linked with Customer_ID of WeekProfile). Can you confirm that this is correct? Link Master Fields: ID Link Child Fields: Customer_ID
		Correct?

[June7]

Yes, that does look appropriate.


A control used to input search criteria must be UNBOUND - no Control Source. Is the combobox UNBOUND?


Where do the Weekprofile values come from? Is there a lookup table for those? Do you have a combobox on the subform for selecting profile?

Can really call this a many-to-many relationships: each customer can have many profiles and each profile can associate with many customers.


If you want to provide the db for analysis, follow instructions at bottom of my post.

[FL0XN0X]

hey,
I think I have found the issue .... the subform must be based on a query which gets the ID from the choosen record via the combobox. Until now, I didn't have this query :-S ...
Working on it now, keep you posted ...

[RuralGuy]

I believe you are now on the right path.

[June7]

Wait, the query for the main form should be based on chosen record of the combobox, assuming main form is bound to Customers table. (I never use dynamic parameterized queries, I prefer VBA to set the form Filter and FilterOn properties.) The subform should just be the Weekprofile table or a simple query with no filter criteria. The subform container Master/Child links will synchronize to display only records related to the main form record.