Main Form Combo Box not Updating Subform Query

[Patski]

Hi There,

I'm having difficulty with what is probably one of the more simple functions of Access. I have a Main Form (Search_frm) with an unbound combo box on it called 'SelectDiscipline' - this combo box is reading from a table called 'disciplines' which only has 2 fields (ID & Disciplines).

Below that is a subform which is linked to a query named 'lessonslearnt_qry'. The criteria in the corresponding field I have
[Forms]![Search_frm]![SelectDiscipline]

I want to be able to select a 'discipline' from the combo box which then filters the subform query to results that match the combo-box.

It works when I click on Design view and then return to form view - but that's pants, I want it to update on selection/lost focus/click or something.

Does any one have any solutions??

Many Thanks
Patski

 

[GaryPanic]

no idea - but how about afterupdate .requery ????

 

[Niniel]

I have a similar problem, and yes, I put docmd.requery in the combo-box's After Update event, and it worked.

 

[Patski]

Many thanks, it's worked.