Queries, see new fields when table design has changed

[MiataMX5]

I have added a field to a table underlying a query. The new field does not
show in the field drop down list in query design mode. How can I refresh the
field list without deleting the table from the design then adding the changed
table back into the design mode. I don't want to lose my criteria and
selected fields.

 

[Jeff Boyce]

This may be a bit of a kludge, but you could add that table a second time,
change all the fields' tables to the new instance, then remove the original
table. This would preserve the fields, criteria, etc.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John Spencer MVP]

Normally, all you have to do is
-- Save the table change
-- close the query if it is open
-- open the query in design view for the new field to become available in the
query.

If that is not happening, please tell us more - such as your version of
Access, whether or not the table is being used directly in the query or is
part of another query that is being included in the query where the field is
not available.



John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County