Enter Parameter Value on deleted fields.

[Locopete99]

Hi Guys,

I'm setting up a database at the minute and I have created a table (Tbl_ShikomiRegister) and a Form (Frm_ShikomiregisterINT).

I removed a couple of fields from the table that were not on the form as I decided that they were most suited to being on a different table.

The only problem is I now keep getting a request to "Enter Parameter Value" on the removed fields. How do I get Access to understand that they are now not on the Table or Form and to forget them completely?

 

[Gasman]

Take them out of the query that supplies the form?

 

[bob fitz]

Could it be that you have a control on your form (possibly a combo box or a list box) that makes reference to the deleted fields in its Row Source property

 

[arnelgp]

remove them on your form's Record source.
if the form is based on query, remove it from the query.

 

[Locopete99]

Thanks Bob and Gas Man, I keep forgetting the control source for the form!