Changing a Query using VBA

[k209310]

I am aiming to search a database for required information as entered by a user and for this info to be displayed in a spreadheet. The info is enterd in to a message Box within Excel which is named strFileName.


I need the criteria to be enterd by the user in to the message box and for this information to be set as the varibale within a WHERE functiion in a query .

Does anybody know of a weay of doing this?

 

[The_Doc_Man]

Try searching this forum for topics such as "Dynamic search queries" or "Dynamic queries" or "Cascading Combo Boxes"

Several of these topics address the issue you mentioned.