On Thu, 7 Aug 2008 13:18:05 -0700 (PDT), julie wrote:
> I have created a form using the wizard, from 7 different tables.
> After completing the wizard, I realized I left a field of of a table.
> I went back to the table, added the field, and am now having trouble
> adding that new field to the form. The new field is not listed in
> the
> Field List, nor in the properties box of a new control that I create
> from scratch. Also, when I do enter the tbl name in manually, I get
> an error in Form view when I try to add data: "Control can't be
> edited; it's bound to unknown field..." and in the text box, it
> populates itself with #Name?, which can not be deleted. I've tried
> everything that every book and help website and training class is
> offering. Short of recreating the form, what can I do?! (access 2003)
If your form is getting data from 7 different tables, that means a
query (or SQL) is the record source for the form. You first need to
add the field to the query, then it will be available in the field
list.
However, with that many tables, it's possible that your form is NOT
editable.
See Access help on:
Query + Troubleshoot query + Specific Type of Query + Select Query + I
can't update data from a query.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
|
