Module Problem

[Guest]

I am trying to update a module & form which should allow me to click on a the
form and automatically download reports into excel. At the moment I have
changed the coding in the module and the form in design view and when I run
each of these the report is downloaded/exported correctly. However when I
try to click the form in the form view the new coding does not run. I am not
sure what else could be wrong. Sorry if I am using the incorrect wording as
I am new to this.

Thank you for any help that could be provided.
JR

 

[George Nicholson]

Check the OnClick event property of the Form in Design view. Does it point
to your new code?

It sounds like maybe you added the code in the form's module but forgot to
"connect" it via the form's property sheet. Access will frequently be
helpful and "fill in" the form's property sheet for you, but sometimes its
psychic powers are lacking.

HTH,

 

[Guest]

Thank you George - I have tried this and the form's property sheet is filled
in to match the new module coding. I have run in both the module coding and
the form property sheet and each work correctly. But as I said before when I
try to run it the "regular" way the new coding does not come through. I'm so
very confused.

I appreciate your help - thanks again,
jr

 

[kakha Sikharulidze]

I am trying to update a module & form which should allow me to click on a the
form and automatically download reports into excel. At the moment I have
changed the coding in the module and the form in design view and when I run
each of these the report is downloaded/exported correctly. However when I
try to click the form in the form view the new coding does not run. I am not
sure what else could be wrong. Sorry if I am using the incorrect wording as
I am new to this.

Thank you for any help that could be provided.
JR