Expert: Bob Heifler - 11/2/2009

Question
I am working in Access 2003.  The form that i am working on i have to add new information into these fields.  So for example we have 08-09 field in there in which hour information is put in.  Since we are using the same information for these field just updating the hours I copied and pasted these fields and created a new field a renamed it 09-10 and the following showed up underneath it #Name?  How can I get that out of these so it is blank?  Thank you in advance

Answer
The "#Name?" indicates that the form control needs the control source property to be set by you, which can be a table or query field name or an expression such as a calculation.  Go to the form's design view, highlight the form control, find on the property sheet the Control Source property, and fill it in.

Bob Heifler

MyAccessProgram.com
DailyAccessTips.com

Contact at:
http://myaccessprogram.com/Contact.html

Find example files at:
http://myaccessprogram.com/Download.html

Find free video tutorials at:
http://myaccessprogram.com/Tutorial.html