Nevermind... I just re-read your question. What you're trying to do won't work. You can't use a VBA variable or constant in the default value property of a field. You can do it in code, but not directly. I'd recommend using a TempVars value. This would actually make a good tip video. Give me an hour.
This video is Great. I love the TempVars solution. Thank you very much.
Scott Axton
@Reply 3 years ago
Richard maybe a TempVars video has come to it's time?
Advocating on behalf of Adam (as well as myself and others)
Kevin Robertson
@Reply 3 years ago
Yeah, I'm using TempVars a lot in my current database for user logons. Before it was always a Public variable in a module which is how I started this database until any errors generated cleared the variables and I had to go through the login process each time. Not a problem now I've switched to TempVars.
Eduardo BenaimOP
@Reply 3 years ago
Yes. I second (or third) the motion for the video about TempVars. Great Work!!!
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Developer 33.