Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Object deleted from form but still showing when selecting in code 1

Status
Not open for further replies.

netrusher

Technical User
Feb 13, 2005
952
US
I am currently working on some VBA code and when I
select the below field, control?? I was getting an error
Object not found. I deleted the field from the table and
also deleted it from the form and when I peform Me.
this field is still showing like it is part of the form.
Can anyone tell me why and what can I do. The object was
there yet it said it could not find it when I ran the code
but it found it when I was selecting in my VBA. Now that I
have deleted it from the table and the form how can it still
be showing up as part of the form? Help, I feel like I am
going crazy.

Code:
Me.PPEBodyproResults
 

Trying to figure out where the answer I just posted to this question went to, and then it dawned on me that I'd just answered it on another forum! I'll post it here, also, in case someone else comes here searching.

You're getting the Object Not Found error because the object is not there to be found, you've deleted it! What is still there is a reference to it that Access is using with the auto-complete feature of the code editor. IF it really bothers you, you can create a new, blank database and iport all your objects into it. The reference to PPEBodyproResults will then be gone.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!
 
Thanks Missinglinq,

I did that and it works.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top