Access 07 - Use Top portion of Split form to filter data in bottom

[DBnub11]

Hi

I was doing some searching on the web as well as here looking for a way to turn the split form into a search form. Essentially i would like to have the splitform filter the results on the bottom. I do not want to bid it to a query or something as I want to retain the ability to edit the table directly after filtering.

IS there a way to do this without havign a huge vba procedure? I have about 8 fields that I would like to utilize in various combination at the users discretion. I saw something simalar but no exactly what I needed out there on the web but it was very messy.

Thanks in advnace.

 

[vbaInet]

Regardless of the type of form you have, an effective search form must include a substantial amount of code (depending on how you look at it). In your case I would imagine at least twenty lines (which isn't much).

There are some search form examples on the forum.