Adding columns to subforms in VBA

[bennymacca]

Hi,
I have 50+ tables in a database, all with associated datasheet subforms that
are used in various places. I would like to add another column to each of the
tables, for instance "comments." For each of the tables, i have used the
append method to add the field, but this does not update the associated
subform.

is there an easier way to show this field on the subform than adding
manually or creating a new datasheet autoform (my present way of doing it)?

Cheers,
Ben

 

[Douglas J. Steele]

Check what the RecordSource is for your subforms. Odds are it's a query (or
a SQL statement), not the table itself. Adding the new field to the query
(or SQL statement) should solve your problem.

 

[bennymacca]

at the moment, it is the actual table, but i think i shoudl change it to be a
query. that would probably be a lot easier.

cheers