[AccessD] Help on entering data -- when to do it?

[Stuart McLachlan]

Don't do that!

You are changing the "creator id" of the the record every time you view it.

Either set the ID as the Default value for a new record (my preferred solution) or set it in the 
Before_Insert event.

Once it is stored when a new record is created, you shouldn't be touching it.



On 24 Dec 2019 at 14:27, John W. Clark wrote:

> I then call it in the Form_Current and Form_Load events. This seems to
> work in both (in regards to presenting it) and I'm not sure which to
> go with yet. I use the following code behind the events:
> txtNetID.Value = Environ("Username")
>