Forms not Displaying Default Value

T

Tommy2326

In my database I have several forms that require a default value to be shown,
this default value is bound to a field, either Date or Shift. There is one
form I've got where the default value is only shown if the text box it is in
is unbound. This has not been a problem in the other twelve forms I've got,
what am I doing wrong here?

Thanks for the help

Tommy
 
J

Jeff Boyce

Tommy

Just to be clear, forms in Access don't hold data, they offer a view through
to an underlying table (perhaps via a query). If you have a default value
set on a form, unless you have a new record (to which that default would
apply), you don't actually have the default value. Old records
(pre-existing) don't count. They already have values in those fields for
which you've established "defaults".

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Top