Problem opening form after deleting items in table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I deleted items from the table that is related to a form. None of the items
I deleted are in the form, however, when I now go to open the form from the
main switchboard, it is giving me a parameter query by PtID. Why would it be
doing this? (generally) I've looked at all the properties for the form and
can't understand why this is happening.
 
What does this mean, "it is giving me a parameter query by PtID"?

When you open the form, what happens?
 
You might have a filter on the form that is looking for a particular Id.
Or maybe one of the controls on the form is looking for a particular Id

-Dorian
 
If the record source for your form is either a stored query or SQL, then you
have to delete to the non-existing fields as well.

HTH,
Brian
 
by deleting items, do you mean that you deleted fields from the table?

If yes, then one of the queries for some control on the form is/was
using that field as a control/filter/criteria.

Just because the field does not show up as an item on the form, does
not mean that it was not included in one of the queries related to the
form. For instance it may simply be that that field was included in the
query that the form is based on but NOT shown as one of the fields (it
was decided that it was really not needed).

You will have to check every query/ combox / onopen / onload/ oncurrent
event to see if there is something that is being called that in one way
or another is somehow looking for that field name.

Ron
 
Back
Top