Field value to remain constant in data entry?

[sunilkeswani]

Hi

How do I set an access form in such a way that it keeps some field
values constant in an open session?

It is a multiple user data entry form, so I prefer that once a user
inputs his name, the form should display the same name all through so
the user does not have to put it in each time..

Any help would be appreciated.

Cheers
Sunny

[GarthLeicester]

if the data entry form is the 'continuous form' type and not Datasheet
you can put unbound text boxes in the form header.
The user can populate these when they first load the form. Give the
txtboxes nice names like 'txtInputBy' and set this up as the default
value property for the data field. i.e.'=[txtInputBy]'
Every time you go to a new record the field will be populated with
whatever is in the textbox.
The value in the txtbox will die when the user closes the form.
Hope that is where you were going.
Garth
(To err is human - so why do I feel an Ass)

*** Sent via Developersdex http://www.developersdex.com ***

[sunilkeswani]

Thanks Garth

I need to store that name on each record, so what exactly would I need
to do? Sorry if it is a dumb question, but I am a novice user.

Cheers
Sunny

[GarthLeicester]

Ok, very, very basic. Take a copy of the form and we will play with
that. You need to get the input form into design mode and display its
properties. You will see a detail section full of controls and possibly
a formheader and footer section. If there isn't a form header go to
'View' and select form header/footer. Resize them as necessary. Insert a
textbox into the header area using the icon 'ab|' and resize as
necessary using the handles. In the properties box 'Data' section the
controlsource must be blank. In the 'Other' section change the name
property to something like 'txtInputBy'.
Now click on the control in the detail section which is going to take
the default. In the properties 'Data' section set the defaultvalue
property to '=txtInputBy'
Try it and see. Each time you move on to a new record the default value
will populate the box. Remember you are still attached to the live data
even on the copy form.
I guess we are a several hours apart but I keep strange hours
Good luck and ask anytime.

Garth
(To err is human - so why do I feel an Ass)

*** Sent via Developersdex http://www.developersdex.com ***