Form - Ghost Links (Pop Up's)

[Robb @ FLW]

I have a form developed from my basic information table, when I first created
the table I had the following additional fields Link 1, Link 2, Link 3, and
Link 4, I have deleted these fields from the table and now when I open the
form I get 4 pop up's how can I get rid of these pop up's?

 

[Dirk Goldgar]

I have a form developed from my basic information table, when I first
created
the table I had the following additional fields Link 1, Link 2, Link 3,
and
Link 4, I have deleted these fields from the table and now when I open the
form I get 4 pop up's how can I get rid of these pop up's?

Check various properties of the form to see if those fields are referred to.
First check the form's RecordSource property -- it may be a query (whether a
stored query or an inline SQL statement) that lists those fields by name.
If that isn't it, check the Filter and Order By properties to see if they
mention the defunct fields.

 

[Tom van Stiphout]

On Fri, 10 Jul 2009 05:46:02 -0700, Robb @ FLW

Maybe they still exist in the form's underlying query, or on the form
itself?
Good idea to remove those LinkX fields. They would have created a
"repeating group" which is frowned upon by database designers.

-Tom.
Microsoft Access MVP

 

[Robb @ FLW]

Thanks Tom, sorry for the delay response been busy since the holidays. You
hit it right on the head my major from was developed from a query and the
subforms are from tables and I kept going back to the tables trying to find
them. Once again thnak you.