Form Searching

Hi,

I need an urgent help guys, Can you all please help me out in making a search form on Access. I need 4 fields to be search and generate the report to the excel with formatting like this:

For ex:

Database Access:

Name Age Ph Address
AA 23 1234 hhhh
BB 12 4467 qqqqq

So on search form we have these fields:

Name: [ ]
Age:[ ]
Ph:[ ]
Address:[ ]

[Find Button]----> This is Find button where you can click and all the search result will be exported to the desktop in Excel.

OR

It shows us the result in excel another form.


Thanks in Advance guys... Please help me asap.

I already started this topic on another forum but no reply kindly help me

here is the link : http://www.mrexcel.com/forum/microso...-criteria.html

I Don`t have a solution there, Its not the correct one which i wanted.... and if i cross posted so whats the big deal in it i mentioned it here and there also.

Originally Posted by alansidman

If you don't have a solution there, then you should indicate so. The last time I looked you ignored Xenou's posting. How would anyone know that it does not work for you. We don't have an issue with you posting in more than one forum so long as you indicate so, which you have done. I was just giving you back ground information on why it is generally frowned upon. Did you read the link I provided?

Yes sir, I read it and understand that link completely, I was reading the stuff that`s why wouldn't able to answer it properly.

I will be careful for sure.