Look at the attached example.
Passing Data Issue.zip
Look at the attached example.
Passing Data Issue.zip
June7,
Yes, I find it very confusing when to use brackets, when to use an Exclamation point, etc. I have to get a better handle on that. I still am working on trying to understand it better and have been watching videos on it and received a text book today so I can get a better understanding of it. I have developed other db's that worked great and held records for tens of thousands of records and could track materials from when they came in to exactly what lot # of materials they were shipped out on but never got into modules. Now with this one I can see a real benefit to using modules for certain things, the least of which is writing code only once and reusing it but it all falls on who is logged on.
Once I get my head wrapped around the global variables I'll have it, that's just how it works for me, it may take me awhile then all of a sudden I get it and it makes sense, I know there is a way to do it, I just have to figure out how, then make sure the syntax is correct (Brackets or not, exclamation point or brackets, etc.). For instance, I tried to put "user" in the default field in the field control and Access automatically put brackets around it.
Thanks so much for your assistance and understanding.
Using it in a textbox ControlSource, Access expects to find a field name.
Again, if it's a VBA declared variable, do not use brackets or exclamation point or dot. Those are used with Access objects (field, control, table, query, form, report).
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Have you ever looked at the example?