Query parameter from VBA

[ImChard]

I have a form that opens and displays records based on a select query. I want to add a button to the form so thet when clicked there is a prompt comes up that aske for the [Last_Name]to filter the records on and then refresh the form to reflect this.. I can do this in the criteria of the query (Like "*" & [Enter all or part of Last Name] & "*") but then it happens anytime the query is run. I only want it to run when the button is clicked.

 

[SkipVought]

Hi,

Seems to me like you're using MS Access. Try posting in one of the MANY Access forums on Tek-Tips. like forum702.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]