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
|
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. |