CurrentDb.Execute looking in documents instead of currentdb

[Micron]

a ZLS string is still returned

That is a very good point. I forgot that the return value was a zls.


There should be a test for that and if true (return is "") then do one thing, otherwise do other thing.

[Vita]

Yes, and as the Docs mentioned, that places a default value in the input box. The InputPrompt is a ZLS not Null though, so NZ will not work, and so no default is displayed.
I tested the code myself, and that is what happend, hence post #8.

Now if the O/P was to change InputPrompt to variant, it works, a default is displayed, but then if the user presses Cancel, a ZLS string is still returned

I must have misunderstood. I could have sworn I read somewhere that hitting the cancel button on an input box returns null but I can just use an if statement then.
I will attempt to create a relationship with the HeatHistory table and see if I can get Me.Initials to show. If you have advice on how to do this I would appreciate it!

Not sure why I'm still following this given what seems to be mucho discussion about the default value of an input box and such and having no comment on my prior post.
I agree, with OP - a value should be returned by the input box if the user does not enter anything into it. At least that's what the M$ documentation says should happen. However,at this point I'll say that approach makes no sense to me since it appears from earlier posts that if there is no user input, the default value is the same thing every time - 12 characters of the app path. How does that identify any one individual??
Unless I'm missing something I see no sense in the approach. Time to get the credentials of the user making the change/addition - either TempVars or fosUserName function?

I appreciate the effort to still help.
Heatmaster9000_RD4_KL.mdb
11987654321
10
Every frontend has the initials (and if using one the remote connection) of the user. So it can be identified by that as a last resort.
I am not familiar with those functions so I will look into them. Thank you for the recommendation.

[Welshgasman]

Test it all out yourself by walking through the code line by line.
That is what I did. I rarely used inputboxes unless for my use only.

[Vita]

Test it all out yourself by walking through the code line by line.
That is what I did. I rarely used inputboxes unless for my use only.

I got it to work! It works with my InpRs function. I just have to figure out how to filter it to apply to only the record being saved. It does log the time of the edit I suppose I could do it by that.
I couldn't get the tables to link so I could use Me.Initials. I think I can close this post now though.