Search Query

[Mahendra1000]

Hello,



I have created a table with name "Main". It consists of fields ID, Author, Title, Abstract, Page and Published.

I have created a form named "MFORM" with one Text box named "Enter Author Name" and then I created a search button below the text box. [I haven't written any code to search button]

Then I dragged my Main table into this form bottom and named it as "All Results".

So, Now my form MFORM looks like below :

/*

Enter Author Name :


Search Button


All Results : [It displaying all the results]

ID Author Title Abstract Page Published

*\


What I needed?

If I enter author name as Mike and then click on search button then results should display all the details related to Mike.

All Results [At the Bottom of my page]

Should display all the details related to Mike.

Can anyone of you please help me out how to write a VBA code for this search button?

please....

[offie]

First of all it would be better to split the Author name into first and last. So you can search you first and/or last name.

It is not the search button that searches. To search through a table you make a query and specify criteria.

The way that a form is used is that you enter the criteria into the form

So make a query, based on the table, in the Author field in the criteria row enter

Like "*" & Forms!FormName!TextXX & "*"

with TextXX being the name of your textbox (found in properties)


Drag the query you just made (not the table) into the form.

What the search button do is it requeries (run again with new criteria) the query. So if you want to use a macro then just select refresh from the dropdown. If you want to use VBA then type in

 Me.From.Refresh

(this is after you select on-click in properties)

[Mahendra1000]

Hello Offie,

Thanks for your valuable reply.

I had dragged the search query to the bottom of my main page. The form which I had created displaying results in new tab and it's not displaying at the bottom.

I had attached my database. I just need the search results at the bottom of my main form in stead of displaying in new tab. Could you kinldy have a look into it and let me know on this please.

[Mahendra1000]

I got it on my way

I haven't named the subform which resulted in my queries.....