If you want to use the variable in different forms then you will have
to hold it in a separate module. If it is local to one form then
declaring it at the top will be fine.
For FREE Access ebook and videos click here
http://access-databases.com/ebook
On 20 Jan, 00:51, TeeSee wrote:
At the top of one of my form modules I have ....
Option Compare Database
Option Explicit
Private strItem As String
Am I correct in thinking that I can now use strItem in any procedure
within that specific form module? *FOr instance if strItem is defined
as "TeeSee" in OpenForm then it would still be the same value on a
cmdClick event on the same form. Are there any tricks to doing so 'cos
I can't get it to work out.
Thanks