Form dependency

[Guest]

I've got a simple form based on a table. The table ended up with too many
columns in the "count". I saved the table as a new table so the count was
reset. Now I need my form to recognize the new table with regard to the
"control sources". Any suggestions?

 

[Douglas J Steele]

Look at the properties for the form. Change its RecordSource property to
point to the correct table.

For what it's worth, if by "too many columns in the 'count'" you meant that
you'd added and deleted many fields, but that your final table has less than
the 255 field limit, a compact of the database will reset the count.

Also for what it's worth, I never base my forms on tables: I always base
them on queries. You could have changed the definition of the query and not
have had a problem.