Two DBs... Two forms... similar date fields... different results...

  • Thread starter Thread starter Louie Warren
  • Start date Start date
L

Louie Warren

I'm so confused. I created a database sometime ago. It
had a form that was displayed when you wanted to add a
record. That form is displayed with all things blanked
except the create date, which is defaulted to the current
date. I have done the same thing in another database on
another machine. The first form works flawlessly and the
second gives me #Name? What have I done wrong?

Properties DB1 DB2

Name Assigned Date LibraryStart
Control Source Assigned Date LibraryStart
Format Short Date yyyy/mm/dd
Decimal Places Auto Auto
Input Mask 99/99/00;0 9999\-99\-00;0
Default Value Date() Date()

I've been pulling my hair out all day, and I don't have
that much left to begin with! Thanx!
 
Does the field LibraryStart exist in the record source for the form? Have
you typed the field name correctly?
 
Being a copy should make no difference. What happens if you create a new
control for the LibraryStart field?
 
I have actually designated the [tablename]![LibraryStart],
but it won't let me enter anything in the field. What I
need is to default the date to the current date, and allow
the user to change it if required.
 
Back
Top