This is fantastic. I didn't know you can do this with the Locals window. Thank you for taking the time and effort to explain this. To have a fail-safe approach to referencing, to me, is of great value. I've downloaded your database and I'm going to see if I can learn to find my way around...
The like how elegant this method is for finding the main form. Especially if the same form is a subform on different main forms. Thank you for this!
Thanks, Thomas.
I am SO pleased to know about this. I like working with Tab Controls and this information is gold! So, if I am understanding you correctly, if you're on the main form and want to address the subform (on a Tab Control page) you can do:
me.subfrmNotesDetails.Form.NoteText
But when you...
Thank you that is really good to know. However, in my case, the Text Box is actually a subform. I thought the subform was interpreted as a control that's why I thought any control would do. The Text Box is in fact a subform. I always like to strip a problem down to its simplest form and...
I have the following Test Form:
How do I reference the Text Box control Text1 on Page2 of Tab Control TabCtl1 on Form2? I don't know if I am making it more difficult than it is but I tried in many different ways but have been unsuccessful so far. It seems to be quite the 'path' to travel...
I am really thankful for the incredibly quick and valuable responses I have had to my post. You pointed me in the right direction to unravel the mistake I had made. This is clearly the forum to watch and learn from.
I thought it might be valuable to document the consequences of making changes...
Just in case it may be of some help:
I also use popup forms primarily. I found that I'd size my form to a certain size in Design View. Then in Form View it would show wider. The problem was resolved when I set the Scroll Bars property to Neither. This is because Access seems to add space...
Many thanks for responding so quickly. I had to walk away from my desk to clear my head and now that I'm back I am NOT able to reproduce the problem I stated. My sincere apologies for this.
In the many attempts I made to fix my own problem, I made a number of changes. The field in question...
I have a table with a text field (Short Text). Also, I have a form that displays the contents of that text field. On some records the text is displayed with the HTML tags: "<div>my text</div>". These HTML tags are not part of my text. Where are these tags coming from? Does anyone know?
I am...