Creating Filters on a Form

[Nixx1401]

I have a form which has the following fields:

StrContactNo, StrLName, StrFName, StrAddressLine1, StrAddressLine2, StrParish, StrMale, StrFemale



The form is continuous and is a pop up form.

I would like to filter the data by Last Name on the form so as to the view a particular person rather than having to scroll down the list.

I tried the filter option which on Northwind database and cant seem to get it to work, I tried this link http://www.freevbcode.com/ShowCode.asp?ID=4668 not working, and several others on the internet cant seem to get the filter to work.

[jbarrum]

I do not think that a filter is what you want. How will you decide which person you want to look at?

[Nixx1401]

I would have search by last name which will display all the names beginning with a particular letter. If you have better solution feel free to suggest.

[jbarrum]

The easiest solution would be to create a combo box which gives you drop down on the name field and allows you to scroll through the list and find the person and select them. You can bind the combo box to the record so that when the name is selected it gives you only the record for that person. The tool box/combo box wizzard makes it easy and I can walk you through it if need be.

However, if you want the user to start typing a name and have a list appear based on the letters they begin typing this will require advanced VBA code and will be above my head. but I am sure there are people in this forum that would know how to do that. NTC, llkhou, and RG are all very knowledgable.

just let us know what you want to do?

[Nixx1401]

The suggestion with the list appearing based on what is typed is ideal. I will probably have do some more research since you dont know the code