Cannot locate VBA code for MsgBox!

[sjl]

Hello,



I developed an Access database several years ago, and now I need to change a few parameters. In one of the subforms (of the main Form), when two particular dates are equal, a "MicroSoft Access" message pops up with the message (that I must have written): "Approval date must be later than the submission date". I need to change the code for this (to allow the dates to be equal), but I cannot find either the algorithm nor the MsgBox ! I have used Find to search all my VBA code and it just is not there!

And, I looked at the event procedures of each field of the subform (and the main form), to no avail.

Any ideas where the MsgBox/code could be hiding !?!

Thanks much,
sjl

[June7]

Check the Validation Rule and Validation Text properties of the controls. Any macros in the project?

[boblarson]

if necessary, you can use the FREE V-TOOLS which has a thing called TOTAL DEEP SEARCH and it can find things like that for you.

[sjl]

Thanks guys.

Yes, I have checked the validation rules and texts; do have macros but doubt algorithm would be there (but will double check).

Bob- I was keen on using the v-tools but just cannot get it to install (even with their hints)....guess will have to see if I.T. will give me the right permissions (doubt they will).

If anyone has any other thoughts--I'm still stuck!

thanks,
sjl

[June7]

I use Rick Fisher's Find and Replace (cost about $50). Has been a life saver.

Do you want to provide project for analysis?

[SteveH2508]

This sounds to me like a table level validation. Bring up the table properties and it should be lurking in there under validation rule and validation text.