Form not doing what it's supposed to do.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a table I have a fied named "fldCreator." On my form I have a txt box
named txtCreator with the default value set to =CurrentUser(). It is not
updating the the table. I can't figure out why. Any help would be greatly
appreciated.

Thanks, Rob
 
In a table I have a fied named "fldCreator." On my form I have a txt box
named txtCreator with the default value set to =CurrentUser(). It is not
updating the the table. I can't figure out why. Any help would be greatly
appreciated.

Thanks, Rob
Click to expand...

Is txtCreator bound to fldCreator? If not, this would prevent the
update. If you are trying to perform the update manually through code,
providing detailed code would help troubleshoot.

- GH
 
Yes, the control is bound to fldCreator.

GH said:
Is txtCreator bound to fldCreator? If not, this would prevent the
update. If you are trying to perform the update manually through code,
providing detailed code would help troubleshoot.

- GH
Click to expand...
 
In a table I have a fied named "fldCreator." On my form I have a txt box
named txtCreator with the default value set to =CurrentUser(). It is not
updating the the table. I can't figure out why. Any help would be greatly
appreciated.

Thanks, Rob
Click to expand...

A control's default value property will apply only when the record is
"dirtied" by (manually) adding data to some other field on the form. Are you
doing so?

John W. Vinson [MVP]
 
Yes. The wierd thing is is that when I'm on a new record I can see my
userName. But after I add to the record it goes away and doesn't add it to
the table. Thanks in advance for your continued assistance. Rob
 
Consider posting the solution you found. Other folks visiting this
newsgroup might benefit from how you solved the issue...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top