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