Default values

R

Ron

Hi,

I want to use individual views for people to update a table in an mdp
project.

Is it possible for each persons name to appear in the name field their new
records by default. At the moment they select their name from a combo box.

Cheers,
Ron
 
A

Al Camp

Ron,
If you're users each log in via a UserName and Password, you can make the
default value for the field...
=[CurrentUser]
That will place the UserName into the field on a new record.
 
R

Ron

Thanks Al,

I'll explore that possibility.


Ron



Al Camp said:
Ron,
If you're users each log in via a UserName and Password, you can make
the default value for the field...
=[CurrentUser]
That will place the UserName into the field on a new record.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Ron said:
Hi,

I want to use individual views for people to update a table in an mdp
project.

Is it possible for each persons name to appear in the name field their
new records by default. At the moment they select their name from a combo
box.

Cheers,
Ron
Click to expand...
Click to expand...
 
Top