Designing new database... when creating text box, getting "error" appearing
as #Name?. if text is able to be written in this box, the entry appears on
ALL pages in the database. How do I correct this issue?
Golfinray - 28 May 2008 21:23 GMT
If you are getting #name that means the database cannot find the source for
that textbox. Make sure it has a source on a table or query then right click
on the texbox and in properties check the record source to see if it is
correct.
> Designing new database... when creating text box, getting "error" appearing
> as #Name?. if text is able to be written in this box, the entry appears on
> ALL pages in the database. How do I correct this issue?
John W. Vinson - 29 May 2008 01:16 GMT
>Designing new database... when creating text box, getting "error" appearing
>as #Name?. if text is able to be written in this box, the entry appears on
>ALL pages in the database. How do I correct this issue?
The textbox needs to be bound to a table field.
Are you perhaps making the rather common error of creating a Form first?
Don't. Forms are *just tools*, windows onto the data in Tables. You must
create and properly relate your tables first, and *then* base forms on those
Tables.

Signature
John W. Vinson [MVP]