Access form field won't allow data entry

  • Thread starter Thread starter BearPair
  • Start date Start date
B

BearPair

I have constructed a simple Access database for keeping
track of quotations. One of the columns is set up for
entry of a "short date", and works fine in the TABLE
format. When I bring up the FORM I created form it, all
of the fields in this column display: #Name? When I try
to manually enter a new date, it doesn't allow me to type
over the display. Can you help, please? Thanks!
 
BearPair said:
I have constructed a simple Access database for keeping
track of quotations. One of the columns is set up for
entry of a "short date", and works fine in the TABLE
format. When I bring up the FORM I created form it, all
of the fields in this column display: #Name? When I try
to manually enter a new date, it doesn't allow me to type
over the display. Can you help, please? Thanks!
Click to expand...

What's the Control Source property for that field on the form, as shown
on the Data tab of the field's property sheet?
 
Dirk, thanks!
Control Source indicates "LAST USED" which is the title
of the column of data...?
Terry
 
BearPair said:
Dirk, thanks!
Control Source indicates "LAST USED" which is the title
of the column of data...?
Terry
Click to expand...

Hmm. The #Name error means that Access doesn't recognize the name of
some control or field. Check the underlying table in design view and
make sure that "LAST USED" is really the name of the field, and not just
the Caption of the field. Then check the form's Record Source property
to see if it's really the table itself, or a query based on the table
(whether a stored query or a SQL SELECT statement). If it's a query,
make sure that the [LAST USED] field is in the list of fields selected
by the query.
 
OK.. I'll do some more checking... As you'be probably
figured out, I'm relatively new are creating DB's in
Access, a whole different game than simply being
a "user!" Thanks!
-----Original Message-----
Dirk, thanks!
Control Source indicates "LAST USED" which is the title
of the column of data...?
Terry
Click to expand...

Hmm. The #Name error means that Access doesn't recognize the name of
some control or field. Check the underlying table in design view and
make sure that "LAST USED" is really the name of the field, and not just
the Caption of the field. Then check the form's Record Source property
to see if it's really the table itself, or a query based on the table
(whether a stored query or a SQL SELECT statement). If it's a query,
make sure that the [LAST USED] field is in the list of fields selected
by the query.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)



--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


.
Click to expand...
 
Back
Top