Subform wont filter

[dubmunkey]

Hi all,

i have a subform as part of a larger form used for entering grades.

the form references a table with grades for all terms, im trying to get the form to just display the grades for this term which is identified by a field: ExamId = JsGrades2 using the filter option in the properties box for the form.

I dont have a filter applied to the main form and ive tried putting the filter on the table instead but either way doesn't work.

i could do a query and reference the table but would like to know why i cant the get the filter field to work.

cheers

greg

 

[Sergeant]

Setting the Filter property just sets up a filter...sitting there ready for action. You have to turn it on. You can do this in VBA like "Me.FilterOn = True". You can put that in the form Load event or elsewhere.
You can also set the Filter in VBA like
Me.Filter = "ExamID = 'JsGrades2'"
or
Me.Filter = "Exam = '" & Me.MyComboBox & "'"
...and then go
Me.FilterOn = True

 

[dubmunkey]

You star!! i wasn't aware some properties needs activating in vb.

thanks very much!