Problem with forms after changing table

[winterh]

I have made my form from one of my tables with the fields I want (all good so far), then I have decided to remove some of the columns from the table which are not being used within the table or the forms.



When I re-open the form I get a box which says something along the line of "missing parameters" and the removed column name, if I hit enter is goes, but returns every time I open the form.

Any ideas how to fix this.

[AccessMSSQL]

Yes, there are probably still text boxes in your form that point to the fields you deleted. Go into the forms design mode and delete the texboxes that point to the old fields. There also may be fields explicitly defined in the recordsource of your form. You can check this by going to the form properties and examining your RecordSource property.

[winterh]

I have already checked the form in design model and the box are not on the form.

I have a had a quick look in properties, how do I remove them from the property box.

[TG_W]

If you created the form and then are grabbing the data through the query builder, make sure the fields are not selected there. To check, go to the Property Sheet, go to the Data Tab and click the "..." in the Record Source.

Hope that helps.

[winterh]

Thanks Mate, all sorted

[TG_W]

You're welcome. Glad I could help.