field refresh missing

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

This is rediculous but I need to know if I am losing my mind.
I'm creating an entry form for an access (2003) database. After
creating a form I decided I wanted to add a field. I edited the
database and added the field. Back in the form I would like to add the
new field to the form. The problem is: it's not in the available
fields list. According to the documentation there should be a refresh
button. It's not there. What's more, it does not appear to exist so
that I can add it to a toolbar.

Another thing . . . if I create a brand new form the new fields are
listed there.

Anyone know the trick to fix this behavior?

Needing a refresh.
 
1. Open your form in design view.

2. Open the Properties box (View menu).

3. Make sure the Title bar of the Properties box says "Form" (i.e. you are
looking at the properties of the form, not those of a control or section).

4. What does the RecordSource property say? (Data tab).

There are 3 possibilities:
a) It's a query. Solution:
- Open the query in design view, and add the new field to the query.
- Then reopen your form.

b) It's a SQL statement. Solution:
Click the Build button (...) beside this. Access opens a query-like window,
and you can add the new field.

c) It's a table name.
In this case, the field name should automatically be in the FieldList for
your form once you reopen it. If not, the database is partially corrupt, and
Name AutoCorrect may be the culprit. Post back if you strike this. Basic
info about this problem area:
http://members.iinet.net.au/~allenbrowne/bug-03.html
 
Back
Top