Error when trying to delete a subform

[pachad]

I used the Access form wizard to create a form with two subforms on it. Subsequently, I decided to remove one of the two subforms. I did this by selecting the subform in design view, and pressing the 'delete' key.

Now, whenever I open the form I get an access error message stating "Microsoft Office Access can not find the field 'OldSubform2' referred to in your expression". After clicking 'ok' the form opens fine.

How do I get rid of the error message?

 

[MajP]

Do you have code behind the form? If you have something that references that control like an on open event with:

Me.oldSubform2.setfocus = true

you will get that error

 

[pachad]

No code at all.

 

[PHV]

And no ControlSource referencing OldSubform2 ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MajP]

And no reference in the query, or a controls default value. There are a lot of places to check.

 

[pachad]

No, no and nope.

Thanks all, but I guess I'll have to just redo the wizard.
I also tried deleting the dependancy from the dependancy window, but i could not delete from there.

Thanks again.