New If Statement Post

[John Vinson]

It says cant find the form TimeCards

THANK YOU.

That's the problem then. The form TimeCards is evidently not open.
This query will not work unless there is a Form named TimeCards and
that form is open at the time the query is run. This does not appear
to be the case.

John W. Vinson[MVP]

 

[John Vinson]

The for TimeCards (This is the main form) is open and the sub-form
TimeCardPaymentSub (Sub-form) is on this form.
I even opened both forms and ran the code, but this time it says it could
not find TimeCardPaymentSub
Code is being triggered from another sub-from named Vendor_List on the main
form.

It sounds like the form may be corrupt.

I'd suggest (if you have not done so) Decompiling and then Compacting
your database, and then compiling and compacting again. Instructions
at http://www.granite.ab.ca/access/corruptmdbs.htm.

You might even need to use Application.SaveAsText to write the form
out to disk, and then Application.LoadFromText to restore it.

John W. Vinson[MVP]

 

[Dave Elliott]

I show no symptoms of corruption, even after checking with article.
Even so I decompiled, repaired and compiled again with the code still not
working.
Everything else works fine with NO errors.
Thanks for your help though.

 

[John Vinson]

I show no symptoms of corruption, even after checking with article.
Even so I decompiled, repaired and compiled again with the code still not
working.
Everything else works fine with NO errors.
Thanks for your help though.

I've been working on this too long to give up now!

Dave, if you're willing, please compact the database, WinZip it, and
email it to me at jvinson <at> wysardofinfo <dot> com. There's got to
be some sensible explanation why this isn't working, and I'm just not
seeing it.

John W. Vinson[MVP]