Access Form "Enter Parameter Value" Msgbox 1

[valdosta]

Hi,

I removed a field from Access form. The form worked fine. But after I delete the corresponding column from the underlying table, then the Msgbox pops up when I open the form, asking to "Enter Parameter Value" for this deleted field. How can I get rid of the Msgbox? Thanks in advance!

 

[ajdesalvo]

Is the recordsource for the form a query by any chance, or is there a filter being applied. In this case you have to remove the column from these, also.
Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"

 

[valdosta]

Thanks, Anthony!

I created this form using Wizard out of 3 tables. When I look at the "Field List" from the design view, the title is a query that still select the deleted field. But the field is not used anywhere in the form. How can I remove the field (from the query) ? Thanks!

 

[ajdesalvo]

In the forms' Recordsource property, click on the elipsis button to open the query up in the QBE grid. Locate the field and delete it there. Close the QBE grid and select Yes to save the changes. Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"

 

[valdosta]

Thanks, Anthony!!! It works and solves my problem