Form Filters and use of Me keyword

[doco]

I found a curious use of the keyword Me as used in asample database found here.

The author was using the keyword as a function

  Me( index )

I have never seen that before and am not quite understanding what is taking place; and I can find no documentation on this usage. Is anyone familiar with this and where the docs may be found - if any?

TIA

 

[vodafrog]

This sample database uses five comboboxes in order to choose upto five filters. To cut down the amount code used to create the relevant search criteria they have used the following: -

Me("Filter" & intCounter)

This peice of code refers to the following

Me = refers to the form

("Filter" refers to the first part of the combobox name

& IntCounter) this adds a number by concatenating the value of IntCounter to the text value of "Filter".

As IntCounter is increased in value one by one up to five, it will do the following: -

Filter1
Filter2
Filter3
Filter4
Filter5

This is just a quick way of referring to controls on a form, especially if you have multiple instances on the same form.

Hope this is clear enough.

 

[doco]

Hope this is clear enough

Yes, thank you.