Deleting a field from a form created using the wizard

[optimus_1]

Hi

I have created a form using the data from a table. When creating the form i have not used all the fields from the table.

I have gone and amended the table by deleting a field i no longer require and now when i launch the form it asks me for a 'parameter value' for this field that no longer exists.

Is there an easy way to resolve this? Is there something im not doing?

Thanks

 

[Guus2005]

There are two ways to resolve this: Restore the deleted fields back into the table or you can remove the bound field with the same name from the form you created using the wizard.

 

[optimus_1]

Where do i find the bound field in the form?? When i go into the form design i can only see the bound boxes that i am using. the field i want to delete is not one i am using and is hence not visible.

Should i be looking somewhere else?

Thankyou for your help

 

[missinglinq]

Forms don't request parameters; neither do Tables! Only a Query requests parameters. This means that your Form has to be based on a Query. The problem is that you removed the field from the underlying Table, but did not delete it from the Query.

You could add the field back to the Table, being careful to give it the identical name as before, but that's adding extra baggage to your database you don't need. As you've found out, not having the bound field on your form doesn't help. The Query, when it's run to populate the Form, will still request it with the Parameter Box. You need to go into Design View (QueryGrid) for the Query and delete the field from there.

 

[optimus_1]

Cheers

That has resolved my issue perfectly.

Thanks to all

 

[missinglinq]

Glad we could help!

Linq