[ElmerFudd]

I am updating a simple database of Contractor info on a one table database.

I needed to add an E-mail address to each of the Contractor records.

From Form View, I selected Design View, then I copied the "Fax Number" label and text box, then pasted them.

I changed the Name and Control Source and deleted the input mask and it worked fine. (A new column called "E-Mail Address" shows up in the table and works with the input form)

I needed to add a 2nd e-mail address for each record and repeated what I had just done, only starting with the E-Mail Address Label and Text box.

"E-mail Address 2" shows up in the table, but I get #Name? in the form. "E-mail Address 2" does not show up in the drop-down for the control source, as "E-mail Address" did before, so I had to type it in.

Any suggestions??? (I haven't used Access in 10+ years and am clueless)

Thanks

[OBP]

Elmer, welcome to the Forum.
You can't just type the Control source field name in, it has to be in the Field List or in the field's drop down list.
Double checvk the Table name, create a query based on the table using all fields and check that the filed is in that. If it is use the query as the Record Source for your form.

[ElmerFudd]

I created a query. I've attached a couple screenshots.

"E-mail Address 2" is in the table, but doesn't show up in the Query.

[OBP]

It is not on the Field List in the Query, I would remove the field from the Table and create a completely new Field with a slightly different name, maybe "email Address 2" and see if that appears on the field list of either the query or the Form.

[ElmerFudd]

It worked. Thanks!