Using an Event to poplulate a table

[tg112001 via AccessMonster.com]

Hi,

I have a form with 3 text boxes. These text boxes have an expression in
their Control Sources such as pulling the network ID of the user
[=fOSUserName()], current time [=Now()] & server name ["Srvr1"].

The user will never see these text boxes but I would need the values added to
1 line on a table via an On Close or On Click event. Can someone help me
with the coding of this please?

Thanks!

 

[tg112001 via AccessMonster.com]

NEVER MIND! I FIGURED IT OUT.

Hi,

I have a form with 3 text boxes. These text boxes have an expression in
their Control Sources such as pulling the network ID of the user
[=fOSUserName()], current time [=Now()] & server name ["Srvr1"].

The user will never see these text boxes but I would need the values added to
1 line on a table via an On Close or On Click event. Can someone help me
with the coding of this please?

Thanks!

 

[Rob Parker]

Assuming that you have fields in your form's recordsource (table or
(updateable) query) for these three items, the standard way of doing this is
to use the form's BeforeUpdate event to populate the fields. This ensures
that they always show information regarding the latest data entry or edit,
but they will not change if a user simply views the record in the form. And
you don't even need hidden textboxes on the form for the data; all you need
is code such as:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.UserName = fOSUserName()
Me.LastUpdated = Now()
Me.ServerName = "Srvr1"
End Sub

Substitute the names of the fields in your table for UserName, LastUpdated
and ServerName. BTW, if you are hard-coding "Srvr1" as a text string, it
will never change, so why bother recording it?

HTH,

Rob