Applying a filter to the RecordSource of a Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

davecoats622 - 21 Jul 2005 17:59 GMT

I have a form called (frmComments) whose recordsource is a table called
(tblComments). The tblComments table contains comments for multiple students
for mulitple examinations. When viewing the Form (frmComments), I need to
"filter" the recordsource so that I only see comments for the current
student. Can I utilize the "Filter" property in the Properties Sheet to
allow only comments pertaining to the current student to be seen? If so, I
have not been able to get the filter to work......it still shows all the
records for all the students. On the Property Sheet under Filter, I entered
"Me.StudentID = 8" which should return only records for student #8. Do you
know the correct format that should be used to enter this filter?

Reply to this Message

Rick Brandt - 21 Jul 2005 18:51 GMT

> I have a form called (frmComments) whose recordsource is a table
> called (tblComments). The tblComments table contains comments for
[quoted text clipped - 8 lines]
> Do you know the correct format that should be used to enter this
> filter?

Me.Filter = "StudentID = 8"
Me.FilterOn = True

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

davecoats622 - 21 Jul 2005 19:26 GMT

Thank you very much. That worked!

> > I have a form called (frmComments) whose recordsource is a table
> > called (tblComments). The tblComments table contains comments for
[quoted text clipped - 11 lines]
> Me.Filter = "StudentID = 8"
> Me.FilterOn = True

Reply to this Message