HELP PLEASE I’m having trouble with one of my forms/

[RJ45]

I’m having trouble with one of my forms/

Here’s what I would like to happen, when a user log’s-in they will be sent to the BaseLog form. (That work’s)

Once on that form if the user enter a “note” entry, I want the S/O filed to be automatically be populated with the user initials.

I am totally lost in coding this; I don’t even know where to begin.

Please help.

 

[Tekime]

When the user logs in you want to record their userId and any other info you will be regularly using to either a table, a hidden form, or a public variable.

I use a hidden form to store my user details.

You can create a form with unbound controls for each of the user values you want available to your scripts. Name them appropriately, and then once login is verified use openform to open the form to hold these values as hidden (frm_Session in my case)., like this:

DoCmd.OpenForm "frm_Session", , , , , acHidden

You can set the values you want like:


Forms![frm_Session]![txtuserId]=rs("userId")


Then from any of your modules you can reference these values. So in the onUpdate event of your notes field you could say

Me![Initials].Value = Forms![frm_Session]![txtInitials]

This is just one method and of course you will need to adapt it to your app.

HTH


edited: Sp.

 

[RJ45]

Any insight would be helpful

Could anyone give an example of what I’m trying to accomplish. I am self-taught; if I could see an example I can play around with the code.

Any insight would be helpful,

Thanks.