So, what is the difference between the "Me!someControl" and "Me.someControl"??
And thanks for your response.
The answer is pretty long winded and I'm not sure if there is a good web-site where there is documented coverage of this. This is paraphrased from a book I have written by Alison Balter called "Mastering Microsoft Access 2000 Development".`
You should use ! (bang) when you are separating objects from it's collection as in
In most cases you can also use a period to separate an object from it's collection as in
This works because it is really a shortcut to the default collection Controls on a form (or report). The entire reference would look something like this
or even longer
You should always use a period to separate an object and it's properties or methods
With all of the above said, you were doing everything correctly, because either way works. Using Me.someControl allows the popup (combo box) so you can select the property or method. I look at it that someday Microsoft is planning to get rid of the ! syntax someday.