VBA Module with SQL help

[fredalina]

Hooray! I found it... In the code:

Case Is < 10
strMyDefaultValue = strMyDefaultValue = "000" & CStr(intPeriodMaxValue)

The second = should be &. Just a mistype.

Thanks again so much for your help!

 

[KenHigg]

Cool - Yeah I found that error as well. If you don't fix the code as per post 19 and you don't have any records for the current month you should get a 'null' error.

If I was you I would explain the issues with placing too much emphasis on this field as a true month count. Other issues exist as well. For instance if a user enters data for a previous month the counter will set the field to the current month.

 

[fredalina]

Will absolutely do. Thank you again.