set default value in field of form in Access 2003

[New to this]

Hi I have been given an Access project which was started by someone else,
where they have 5 forms connected to one table. Right now there is a combo
box on each separate form where the data entry person can select the type of
form. However, to avoid data entry errors, I would prefer the type of the
form (e.g. student form, teacher form, etc.) to display automatically
according to the form being used, and be locked for that particular form so
that it can not be changed by the data entry person.
Is this possible? Thanks!

 

[New to this]

Hi
I have created a switchboard which will take them to the correct form. It's
not that they would switch mid-form, just there is the possibility they may
choose the wrong type of form on the combo box given a choice. All the forms
link back to one main table.

 

[Bob Larson]

That totally sounds like some bad design work though. 5 forms should not be
necessary for 1 table. More information is necessary to help but it really
sounds like it may be a non-normalized design.



--

Thanks,

Bob Larson
Access MVP

Free Access Tutorials and Resources: http://www.btabdevelopment.com

 

[New to this]

I do not disagree with you, but am hoping to do the best with what I've been
given here.
The forms all contain different information. In any case, I have a
Switchboard and a macro opens up each form through the Switchboard. I am
wondering if I can add to the macros that opens up each form so that it will
make visible the type of form (eg Student Form), maybe through SetValue?

 

[Mike Painter]

That would best be done by adding a label on the form to identify it. You
could also consider color coding the forms.
I don't particularly like the switch board and usually build a form with
buttons on it, they could help with the coding.

If the data entry clerk can't tell the difference between forms this project
gets more curious.
The original design where the user made a choice in a combo box may have
been part of the design and was used to tell student records from instructor
records.
If this is nothing but an address book then there is no harm done but it
could be done faster and better with other tools.

Just out of curiosity, how many tables are in this database and how are they
related?