Search Database

**kamalthakur** · 06-26-2009, 05:26 AM

Hi ,

I would like someone to help me out with the Below request.

I have a spreadsheet which has two tabs Search and Database.

Search tab has two combo boxes and a seach button.

Database tab is used to for building up databse.

My query is when I select Country and Supplier and click the button the details requested should be displayed below in search tab and if try to do a new search the previous results should be over written with new results.

I am uploading a copy of this

**royUK** · 06-26-2009, 05:35 AM

Take a look at the databaseform here

http://www.excel-it.com/

Yo can adapt the code for the search button for what you want

**kamalthakur** · 06-26-2009, 05:48 AM

thanks for the response but i am not able to access that website

**royUK** · 06-26-2009, 06:06 AM

The link's fine, this is a direct link to the downloads page

http://www.excel-it.com/vba_examples.htm

**kamalthakur** · 06-26-2009, 06:17 AM

Roy

I am able to download the Example file but that File is helpful to save the data using a macro but my query is to display the data from the database when the macro is executed using the search criteria

**ravishankar** · 06-26-2009, 06:30 AM

Hi
Enter the country in G6 cell and supplier in G8 of search sheet and click search button.Check the result sheet. It clears earlier result(I could not get the correct syntax to get value from the shape combobox.So I have used the cell itself)
RAvi