Details are too vague to provide very focused answers (because I'm quite detail oriented). F'rinstance,
the Form_Load does nothing
doesn't tell us if it even runs. I have the feeling that you won't avoid making this a long thread by not posting your code as mentioned in your first post. Perhaps you can still avoid that by posting the db itself, with instructions on how to replicate your issue. If you do, copy db, compact/repair the copy and zip it. Follow link at top of forum page "How to attach files" if you need help with that. Alternatively, you could try stepping through your code and examining variables/conditions to see if they are what you expect and provide info on what you find.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.