Create a filter

[desireemm]

I want to create my own filter, I was thinking I would create a query and then put the query in a form that users can type in the Id # or the lastname and the results would pop up in another form. But I'm not sure how to do it. Can you help me

 

[DJN]

You are probably looking at query by form. There are a couple of articles and code on the Microsoft Knowledge base that might prove useful.

http://support.microsoft.com/default.aspx?scid=kb;en-us;95931&Product=acc97

http://support.microsoft.com/default.aspx?scid=kb;en-us;136062&Product=acc97

They are both for Access 97 but I don't think there is anything in the code that cannot be used for later versions of Access.

David

 

[desireemm]

Thank you

Thank you so much for the info, those links help alot I'm just trying to find out how to create a query that returns values from what the user chooses. What exactly is that called can someone tell me please that would help alot. I find that in my search for answers in Access help online It helps to know the name of the item your looking for. Helps to narrow down alot of searching

Thank you again