Filtering Subform from Combobox values

[glamster7]

Hi

I have a form viewbookings on which I have a combobox - filtgroupname & a subform bookingsubform. What I'd like to have is - the user chooses a name from the combobox & it filters the subform for bookings for the group chosen. I tried this several times yesterday with no success (I haven't got the code cos in my frustration I deleted it)

Thanks in advance

[glamster7]

I am alright with setting up the combobox - but the wheels seem to come off when I do the event on After Update

[Scott Price]

Assuming you're running Access 2003?

This is the code I've used to do just what you're trying to do (thanks to all for their help on this site!):


[code=vb]Private Sub cboHistYearSel_AfterUpdate()
Dim SelYear As Integer
Me!sfrmHistory.Requery
SelYear = Me!cboHistYearSel.Value
Me.sfrmHistory.Form.Filter = "Year = " & SelYear
Me.sfrmHistory.Form.FilterOn = True
End Sub[/CODE=vb]

This code example is to filter a subform named sfrmHistory according to a new year chosen in the combo box named cboHistYearSel.

Change the names to match your subform name, combo box name, and if needed the variable to String or Variant and it should work!

[glamster7]

Cheers Scott - will give that a try & let ya know how I go

[glamster7]

Does the job nicely - thanks for that