Why am I still being prompted after I deleted the code?

[Access_Novice]

I tried to set a form Order By property = parents.parentID meaning parent Table, then parentID field. I have since deleted that code. But when I attempt to go back into form view I am prompted to enter parents.parentID.



Note: Originally I should have typed tblParents instead of parents. Not sure if this has something to do with the problem.

Anyway, I have deleted the code that I previously wrote, saved changes, and Access still thinks that this line of code is present when it is not. Any ideas what is going on?

[June7]

You deleted the code from where? From the form OrderBy property on the Properties Sheet? Or was this in VBA? I opened your db from other thread. Not getting the prompt.

Actually only need ParentID in the OrderBy property. The tblParents qualifier is not needed because there is no other field in the RecordSource named ParentID.

[Access_Novice]

I deleted the code from the VB Editor.

[June7]

Did the form get saved with that criteria in the property? Look at the Property Sheet.

Why am I not getting the prompt?

[Access_Novice]

Did the form get saved with that criteria in the property? Look at the Property Sheet.

Why am I not getting the prompt?

It was the property sheet. The parents.parentID with [ ] was the value in the OrderBy property. Thank you.

[Access_Novice]

How do I mark this as solved?