How to change query criteria programmatically

[fekrinejat]

Hi
I have a where clause in select with inputbox value like:

where tel = [Enter Telephone]

but i would like to create a Form and put an unbound textbox in order to get this value
and by clicking a button, puts textbox value in sql

would you help me for writing vba code in on_click event ?


Thanks

[pbaldy]

It would simply be:

where tel = Forms!FormName.TextboxName

[pbaldy]

I should have added that's not code, just changing the criteria of the query to point to the form.