NotInList no longer working

[Gicu]

It's yours now! Always helps when you can reuse a procedure, much easier to make changes in one place vs. many....



Cheers,

[moke123]

Actually I don't really use that one. I use the 3rd choice in the attached file.
It makes a half hearted attempt at checking for spelling errors before saving.

[MikF]

Thank you all for your assistance and acumen.

Agree with moke123 about a generic sub, and will sift thru that code to implement.
May need a helping nudge or three.

It's been years since I've had to look at more intensive Access logistics.
Uncertain how it got out of whack [agree I must have changed some aspects along the line], but now have to return it to functional efficiency.

Thanks again all.
- Mike

[MikF]

Hi Vlad,

Re "for the code in post #12 please try to add "DAO." to the declaration statements for the database and recordset variables (the default is a ADO recordset but you are working with a DAO one)."


How specifically to do that ...?

Thank you.

[moke123]

instead of Dim db as database, you add the reference to DAO -

Dim db as DAO.Database 
Dim rs as DAO.Recordset