unbound text fields

rexb

Registered User.
Local time
Today, 00:27
Joined
Oct 29, 2008
Messages
129
I have 3 unbound text fields. textfield1,textfield2,textfield3
textfield1 = date()
textfield2 = computer name()
textfield2 = user name()

how do i save the result to a field in the table. say "date()" should be save on datetoday field, "computername()" to machinename field and "username" to username field.
 
Bind them to the table and instead of using the control source to set them, use VBA instead in the form's Before Update event:
Code:
With Me
   .textfield1 = Date
   .textfield2 = computername
   .textfield3 = username
End With
 
Thanks for helping me
 

Users who are viewing this thread

Back
Top Bottom