Problem implementing error logging as per Allen Browne example

[Fred Boer]

Hello:

Allen Browne discusses error handling at the following link:
http://members.iinet.net.au/~allenbrowne/ser-23a.html

He suggests setting up a table to log error information. I've tried setting
up such a table and am having a problem with the creation of a field to hold
the name of the current user. Allen describes the possible table structure
in a chart. He suggests a text field called "UserName", which has a default
value of "=CurrentUser".

When I try to create a table with this field I get the error message:

Unknown function 'CurrentUser' in validation expression or default value on
'tblLogError.username'

What am I doing wrong, here?

Thanks!
Fred Boer

 

[Jeff Conrad]

Hi Fred,

You can't set up the field at the table level to use the CurrentUser
function. Just set up the table field as Text with no default value. The
CurrentUser value will be passed to the table by the function.

Hope that helps,
Jeff Conrad
Bend, Oregon

 

[Douglas J. Steele]

Can you use CurrentUser in the Debug window? If not, it could be a
references problem.

 

[Fred Boer]

Dang it! Now I can't even *pretend* that I had tried to understand the code
before using it.. <g>

Thanks a lot!

Fred

 

[Fred Boer]

Oh, I *do* love the newsgroups! As soon as I had corrected the error that
Jeff pointed out... I immediately ran into a references error! <g> It is
working just fine now, thanks!

Fred

 

[Jeff Conrad]

Hi Fred,

No problem.
The chart does give the impression that you should set up the table field
with a default value so your misunderstanding is justified.

Jeff Conrad
Bend, Oregon