You can filter the subform's content based on the user's search entry.  In my example below, a short VBA procedure sets the Filter and FilterOn properties of the subform, allowing it to return movie titles containing the text "hallow".  This site should have videos on this.  You need to know about the AfterUpdate event also.  The filter's criteria also needs to be in SQL format.  Also, the use of "double single quotes" (or double double-quotes) inside the criteria is needed too.  All these topics are covered on this site.

thank you for your advice
but i want that the user (based on his selections) should be able to generate a sql that brings data from a few different tables, and only show that few fields that he selected, (filter is not enough for this),
i could make a sql of all the tables and filter only what he selected, but how can i hide all the the fields that he didn't select?

Richard did something similar with a List Box in this video:

Custom List Box

On a datasheet, you can set each column's visibility with the .ColumnHidden property, based on user choices.  E.g.:

     Me.MovieTitle.ColumnHidden = False
     Me.MovieYear.ColumnHidden = True
     Me.MovieCountry.ColumnHidden = True
     Me.IMDbID.ColumnHidden = True
     Me.MovieTitle.DatePurchased = False

Regarding letting the user pick which columns to see, you may let them make the selections with checkboxes.  I rarely do this because (a) if there are lots of columns, which is usually why this is done, the user will have lots of checkboxes to look at; and (b) the user may not know what columns to choose and end up getting useless results.  For instance, if the filter is "MovieGenre = 'Drama'", and the user picks only the MovieGenre column, then he will see a column containing nothing but "Drama", hardly the useful data you want him to see.  You may consider having the columns picked for them.

Thanks Kevin and Kevin. I learned a lot today. one small question is there any techhelp video how to export the data of a listbox or datasheet to excel/PDF? (preferred using vba).

What you want is the TransferSpreadsheet command, and I just looked... I'm surprised I haven't covered it in any Developer lessons yet. I'll have to remedy that. I know it's on my list. Someone a while back asked me another question about it. Video coming up soon...

Thank you Richard. Waiting for the Video

"Someone a while back asked me another question about it. Video coming up soon..."

That'll be me! If Adam can have Tempvars, I have spreadsheet transfers - More Exports!!!!

Dan

I think Richard had to write a db just to manage his Question / Topic / Future Video list.
You do realize that Adam had to wait quite some time right?  Kind of like watching grass grow - you need to be in it for the long haul.

Just like Orson Welles, who promised for Masson, said: "We will sell no wine before its time."


Edit:  
Ohhhh My god.  That makes me old.  I watched that commercial as a kid!

Oh yeah i know. That's why i'm jumping up and down now - Hoping to get something in the next 5 years or so (VIP treatment lol!)

Awesome commercial. LOL