How do I create a cmdbutton to filter records? 1

[Taecca]

I have created a form (continuous) and StudentName, StudentCity, StudentID are some of the columns.

I wish to add a button at the side of a column that when clicked will filter by the value (StudentID) on the current record.


How do I do it?

Thank you and happy new year

 

[KenReay]

Try

Create the button

In the OnCLick Event of the Button put code so

Me.Filter = "StudentId = " & Me.StudentId
Me.FilterOn = True
Me.Requery

This is assuming StudentId is a Number, otherwise

Me.Filter = "StudentId = '" & Me.StudentId & "'"
Me.FilterOn = True
Me.Requery



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Taecca]

Thank you