help! module works only if a module is open

[lanelouna]

hello all
plz help is needed ASAP
my form doesn t seem to work unless i have microsoft visual basic on, and any module open, that is the command buttons, or option groups don't do anything unless a module is open
how come?
plz help
thanks in advance
Lina

 

[gusbrunston]

[tt]
Hi, Lina:

I'd like to help, but...

It would be helpful to have more information. What does it mean, "...my form doesn t seem to work..."? Is the module a public module? How do you call the module from your form? From the 'On click' event of a command button? If the module is public, works when it's "open" then it should work if it's called properly.

Pick a command button that doesn't work, and copy and paste the 'On Click' code here. If it's not a long, long module, copy and paste the code here also. [tt] Gus Brunston - Access2000(DAO)[/tt] Intermediate skills.

 

[lanelouna]

hello Gus
thank you for your help
i never had this problem before, either because i always had the VBA open, or maybe there was a problem in my pc
well today i restarted my pc
and it worked
it is weird
the whole form seemed not responding yesterday, you know, clicking on any command button, or choosing any option, didn t do anything
but now it is working
thank you again for your response, i appreciate it alot
Lina