View Full Version : Trouble with autoforms


smith.stuart
12-27-2000, 09:09 AM
Having created a form from a table using the autoform wizard, how do i change / update the filelist. I have updated my table with new field additions but these new fields aren't appearing in the filelist

Jack Cowley
12-27-2000, 09:27 AM
Hmmm. Not sure what is happening here as this should not happen. Your form is based on the Table and NOT a Query that is based on the Table is it? (Check the Forms Record Source). If so, then be sure to update the query too..... Otherwise I am stumped as added fields to the table do show up in the forms Field List.

[This message has been edited by Jack Cowley (edited 12-27-2000).]

Pat Hartman
12-27-2000, 04:22 PM
Look at the recordsource for the form. The wizard may have created and embedded a select statement that only selected the columns that existed at the time the form was made. You can correct this by deleting the recordsource and readding it or writing your own query and using that as the record source rather than the table. BTW, using a querydef as the record source is the preferred method.