I found this search marco on one of access's templates and I liked the way it functions.. and I want to make something similar for my database so I'm trying to understand what going on iside of it..this is the embedded macro on click:
http://i725.photobucket.com/albums/w...psb305b31f.png
and this is what got highlighted when I selected the control name DS and under the selection type it says that this DS control is a sub-form:
http://i725.photobucket.com/albums/w...ps259b09c6.png
1- what I don't get here is what "searchable" is? is it a name of a control or is like a default command or something? what does it mean?
2- Like all I'm guessing from my very basic SQL knoweledge means show all records correct?
3- [txtsearch] I figured is the name of the text box, but what does the SetTempVar Action do? what is tmpSearch?
4- what does tempVars refer to?
5- what is the ErrorHandler function do and what does =[MacroError].[Description] mean?
help is very much appreciated thanks !