Removing deleted DB field from form

[Guest]

I no longer need a field in one of my tables and have deleted it from the
table. An existing form that uses data from this table requests a value for
the deleted field on entry to the form even though that field is not used in
the table. The field name does appear in the field list. Can I remove this
field name from the table without rebuilding the table?

 

[RBear3]

The query (upon which your form is based) probably includes that field as
well. You deleted it from the table, then you deleted it from the form, now
you need to delete it from the form's underlying query as well. Then you
should be all set.

 

[Guest]

I do not have an underlying query that I am aware of. If there is one, I do
not know how to find it. I built the form using the wizard and then modified
it to the layout I wanted. I am using multiple tables as input to the form.
I am using Access 2007.

 

[RBear3]

Open your form in design view. Double-click the black square in the upper
left corner of the window. Select the DATA tab. click the RECORD SOURCE and
you should see a "builder" button appear on the right. Click it and the
query should open. If that deleted field is there, remove it.

You might also check your form's grouping and sorting to see if that deleted
field is referenced in there. You may also want to look at the form's code
window to see if the form is mentioned in your code.

 

[Guest]

That took care of my problem. Thanks for your help!