Redundant field wont go away?!

[moorsey]

Im quite a way into this database, and I decided to bin one of the fields that I didn't require anymore, so I deleted it from the original table and on all the forms it was referenced on (including the queries behind them)

but every time I open my main form, it comes up with a message box asking me to insert a value for this field, I'm sure it has a name, but its the one that happens when there is an unbound text box or something that has no value

The textbox for this field is not on the frm anywhere, is there anyway I can find it? I'm either going to have to put the field back in and hide it or delete the form and start again, which would be annoying

 

[RoyVidar]

It might be there somewhere.

There's a dropdown in one of the toolbars, listing all controls on the form - you have looked through that?

Then there's the possibility that it is referenced in the controlsource or rowsource of some control. One technique to examine that, is to use the (hidden) method SaveAsText of the application object.

SaveAsText acForm, "NameOfForm", "c:\NameOfForm.txt"

Then you can search through a text representation of your form, and see if you can pinpoint where it is referenced.

Then theres the possibility that it is referenced in code, somewhere. Search through your code.

Finally (if I've remembered all), there's the possibility it's used in conditional formatting. There are some code floating around to inspect that, I'm sure I have something somewhere, I'll dig it up, if the previous suggestions doesn't help.

 

[missinglinq]

The fact that you're getting a parameter box asking for a value for this field tells me that you have a query out there that is still referencing this field, and that query is being run when your form is loading. You say you've checked "the queries behind" the forms; do you have any combo boxes whose queries/row sources referenced the field?

 

[moorsey]

Hi, thanks for the replies, you were both right, I used SaveAsText acForm, "NameOfForm", "c:\NameOfForm.txt" and had a scan through, found that is was still in the query even though I must have checked 10 times!!!! It had Expr: at the start of it, so I had just looked over it thinking it was one of my other expressions

Thanks both!

 

[missinglinq]

Glad you got it straight!