Re: saving information into a tables

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

GlobalTek wrote:
Well I have a form that ask the user for Language selection ( french or
English )
Hide in that form his 3 Text Box, 1 will say the username of the person (
=fosusername() ) the second text box will say the machine name (
=fOSMachineName() ) and the last one will promt the date the form was open (
=now() ) I would like that info to be saved inside a table to know who is
accessing the file in case they is some problem. I tried the thing below and
It did not work, Anyone can tell me or help me resolving the problem please?


It sounds like you are using those expressions in the text
box's ControlSource instead of the DefaultValue. The
ControlSource should have the name of the field in the
table.

Remember that the DefaultValue is only used when you create
a new record. It has no effect on existing records.

--
Marsh
MVP [MS Access]
.

Relevant Pages

  • Re: form closing problem
    ... > Private Sub Form_BeforeUpdate ... > DefaultValue: ... > ControlSource: ATitle ... > selectable from the comboboxes. ...
    (microsoft.public.access.forms)
  • Find string in ControlSource
    ... ormore ControlSource or DefaultValue of controls (generally text/combo boxes) ... string in the .ControlSource or .DefaultValue property? ...
    (microsoft.public.access.modulesdaovba)
  • Re: Entering incremental value into text box
    ... BeforeUpdate? ... You use it as ControlSource of your TextBox or in the DefaultValue. ...
    (microsoft.public.access.modulesdaovba)