Form not doing what it's supposed to do.

R

RobUCSD

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
 
G

GH

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
 
R

RobUCSD

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...
 
J

John W. Vinson

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]
 
R

RobUCSD

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
 
R

RobUCSD

Never Mind, I got it right now. Sorry for the inconvience and thanks for your
help. Rob
 
J

Jeff Boyce

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
 
Top