refresh fields not available

  • 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.
 
Steve said:
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.
Click to expand...

Your form is not bound directly to the table, but rather to a SQL statement
pointing at the table. If such a Statement looks like...

SELECT * FROM TableName

....then new fields added to the table will automatically get picked up by the
SQL statement. If however; it look like this...

SELECT FieldName1, FieldName2, etc... FROM SomeTable

....then new fields added to the table will not be picked up automatically. You
need to edit the SQL statement so it includes the new fields. Or (simpler) just
change the RecordSource of the form so it is just the name of the table. That
will also automatically pick up any changes made to the table.
 
Reselect the recordsource for the form; also, go into the object specified
as the recordsource for the form and make sure the new field is there.
 
I had the same problem. Your suggestion was very helpful. I was able to add
the fields to the Select statement and now I can add them to the form. But
I really like the idea of setting up the Select statement so that new table
fields are automatically available to the form.

I cannot figure out how to modify the SELECT statement to use the wildcard
character "*" when two tables are involved. The current format is:

SELECT DISTINCTROW [Table1].[Field1], [Table1].[Field2],
....[Table2].[Field1], [Table2].[Field2], ... FROM ([Table2] INNER JOIN
[Table1] ON ([Table2].[WO #] =[Table1].[WO #]) AND ([Table2].[S#]
=[Table1].[S#]));

I am using Access 97.

Can you give me any suggestions?
 
Marge said:
I had the same problem. Your suggestion was very helpful. I was able to add
the fields to the Select statement and now I can add them to the form. But
I really like the idea of setting up the Select statement so that new table
fields are automatically available to the form.

I cannot figure out how to modify the SELECT statement to use the wildcard
character "*" when two tables are involved. The current format is:

SELECT DISTINCTROW [Table1].[Field1], [Table1].[Field2],
...[Table2].[Field1], [Table2].[Field2], ... FROM ([Table2] INNER JOIN
[Table1] ON ([Table2].[WO #] =[Table1].[WO #]) AND ([Table2].[S#]
=[Table1].[S#]));

I am using Access 97.

Can you give me any suggestions?
Click to expand...

Try...

SELECT DISTINCTROW Table1.*, Table2.*
FROM ([Table2] INNER JOIN [Table1]
ON ([Table2].[WO #] = [Table1].[WO #])
AND ([Table2].[S#] = [Table1].[S#]));
 
Back
Top