Filtering data by using buttons

[swmasson]

Hi there,

Can someone lease help me? I have very long list of items in a form with one field caled Priority i.e. 1, 2 & 3. I'm wondering how i can have 4 buttons/radio buttons at the top (option= Show all, 1, 2 or 3) which, when selected create a filter showing only that selected?

I hope i have descibed my problem well enough???

Thanks for your help

Kind reagrds

Steve

 

[dom_donald]

Hi, I recently came across this problem. Using a current form ("Me") and a subform containing the data to be filtered ("Form_Name"), the following can be used to filter for records with the "Number" field set to a variable "Num".

Me.Form_Name.Form.FilterBy = "Number = " & Num
Me.Form_Name.Form.FilterOn = True

You can run this code on the events from clicking radio buttons.

Similar thing is "OrderBy".

HTH

 

[swmasson]

Thanks

Thanks very much for the reply,

But i forgot to mention that i have no idea what i'm doing with access??? But i'm trying, i still didnt uderstand what you mean, what else would i have to do?

Thanks again

Regards

Steve

 

[dom_donald]

Hi,

do you know any access vb at all? I don't know how you'd do it without although i'm sure there's a simple way