The Twilight Zone - Help

[rfear]

My database has just started doing some very strange things - like ignoring its 'vba' code, but only occasionally.

It's got me a bit stumped.

The database is supposed to update a calculated value as users enter some data into various fields.

Opening the database from new, the calculation is fine. Enter some data and soon after the calculation stops running.

I've tried to step through the vba but when the calculation is not working it would appear that the code is not being used at all, as the break marker has no effect.

Close the database and start again and all is well ??? I'm very confused.

Does MSAccess vba have a maximum number of lines per module, like MSExcel ?

Any other querks that might be worth investigating ?

 

[boblarson]

Can you post the db? (here's how: http://www.access-programmers.co.uk/forums/showthread.php?t=140587 )

 

[rfear]

In the process of culling the database into a form worthy of posting I've discovered my error.

Seems I had remembered to erase some arrays but forgotten to reset 2 variables half way through the code.

This was having the "twilight" effect of altering my results depending on whether the variables were empty or not.

 

[boblarson]

Cool - glad you got it sorted