subform not loading before main form

  • Thread starter Thread starter riyaz.mansoor
  • Start date Start date
R

riyaz.mansoor

Hi

MS Access 2003 SP2

After I did some refactoring of the subform code, the subform just
would not load. In fact, it skips the subform without any error, and
fails to load the main form as the main form depends on the subform
for some data.

My problem was

Private Const START_DATE as Date = "#00:00:00#"

I had accidentally added quotation marks around the date literal.
Since it was not throwing an error it took me 2 days to track down
this simple mistake.

Hope others won't have to waste so much time!

Riyaz
 
Compile
---

Hi Riyaz,

"Since it was not throwing an error it took me 2 days to track down this
simple mistake."

If you compiled your code, the compiler would have caught this error --
given you a "type mismatch"

'~~~~~~~~~ Compile ~~~~~~~~~

Whenever you change code or references, your should always compile
before executing.

from the menu in a module window: Debug, Compile

fix any errors on the yellow highlighted lines

keep compiling until nothing happens (this is good!)


Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Back
Top