	AllExperts > Using MS Access
	Search

About Bob Heifler
Expertise

ALL MICROSOFT ACCESS DESIGN AND PROGRAMMING QUESTIONS
Free Microsoft Access Tutorial Videos are available to you at my web site. Fifteen years of Microsoft Access experience allows me to answer most of your questions. Common question example files available here.

Experience
Microsoft Access programming since 1994. Support for all versions.

Publications
My Microsoft Access articles are published at:DailyAccessTips.com

Education/Credentials
UCLA GRAD, Member of Association of Database Developers

Awards and Honors
AccessToExcel.com has won several shareware awards for assisting analysts in moving data from MS Access to Excel.

Past/Present Clients
See some of my past clients here.

You are here: Experts > Computing/Technology > Business Software > Using MS Access > form fields

Using MS Access - form fields

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

Ask a Question