macro to filter data on query

[smile]

Hi, I need to make macro that would open my query (pagrindinis_faktura)
find fieldname "Faktura" then in criteria enter information asked using popup message box. I will enter numbers like 21, 45 etc.

I also need another macro that would reset so it would not filter anything.

 

[elbweb]

all you need to do for that is within the query put an unknown variable for the criteria, and then whenever the query is opened, it will prompt for the variable, no macros involved