Default values

  • Thread starter Thread starter Ron
  • Start date Start date
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
 
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.
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo Box Error 2
Excel Concatenate Form Name to Parse for function 1
Opening Forms based on Combo Box Selection (Access 2007) 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Problem with default value updating table 18
code will and won't work 1
Combo Box default value 3
Field concatenation into a combo box 5

Back
Top