Help getting a search button to work

[Barrelwaves]

Hi there people, i have created a query that searches through different fields within the database, and on its own works fine, enter some or no data and it will return what you have entered. The problem is i have created a form with text and combi boxes on that i can enter the query parameters into in one place, but i can not get the search button to use this data and filter the query? the query is a subform on the main search form and is refreshed when the search button is pressed but with no filters defined by the text/ combi boxes. can anyone help please?

 

[Brianwarnock]

I've never done it this way, I've always had the command button to run the search on the same form as the text and combi boxes. I would hazard a guess at an addressing issue, but don't know the how or why. Can you not run the search from the main form?

Brian

 

[rainman89]

unless you are running a new search with the button click based on the selections, i dont see how this can be done. unless you can add filters with button clicks. you are probably better off writing the same query but putting

forms!frmname.txtboxname AND forms!frmname.comboboxname

as the criteria of the search query

 

[Barrelwaves]

Thanks guys i have actually managed to sort it now, it was an adressing issue, i have forgotten to put txt or cbo before the textbox names in their properties!!
Another question though, quite funny one, i finished off the database by removing some of the Access menus at the startup, but now i need them back to change something! any idea how i re-enable them?? the database is basically opening stand alone at the moment. Thanks

 

[neileg]

Hold down the shift key as you open the database.