Linking Textbox to table

[Rakesh935]

Hello All,

Requesting help for the below mentioned requirement....

I have two textboxes which is populating the system name and date, and the same is not getting recorded in the specific table's row. Hence, requesting in helping me to build the vba code in order to record the data.

Note: I can't change the row source since it's already updated with "=computername() for system name and =now() for the date.

Thank you
Rakesh

 

[JHB]

[FONT=&quot]Place "computername()" and now() as DefaultValue for the fields.[/FONT]

 

[Rakesh935]

Hi JHB,

Many thanks for the response...

But afraid to say that I am not getting the desired result, if I place "computername()" and now() as DefaultValue for the properties fields of the form. It's in fact not showing both system name and date in the form. Is there any other way possible...

Note: For your information, I have a set a module to get the system name and below is the code

Function GetComputer()
GetComputer = VBA.Environ("Username")
End Function

From that I give the row source as =GetComputer() and I am still struggling to auto update the current date of system to get recorded in the table...

Please refer link: http://www.access-programmers.co.uk/forums/showthread.php?t=219137

Thank you
Rakesh

 

[JHB]

By me it works, se attached picture, (Standardværdi=Default value).