HELP! My Subform cant trigger any Event.

[edisonl via AccessMonster.com]

help! someone.. this is driving me nuts & I don't get it..

I am doing leave application, currently reaching Cancellation of Leave.

A. Situation:
- Form 1> User Choose Type of Leave to Display (Eg: Child Care Leave, Annual
Leave) From Combo Box

- Form 2> Only consist of 1 Subform (With Empty Record Source) Allowdeletions
= true


B. Problem:
- When user Delete (using keyboard), I like to capture that event so that
Data can be update on another table (Restore back Total Days taken)

- But I can't trapped any event from subform (Eg: MouseClick, KeyPress, Load)

What is Happening ?

PS: I am using Access 2k by the way

 

[Stefan Hoffmann]

hi Edison,

- But I can't trapped any event from subform (Eg: MouseClick, KeyPress, Load)
PS: I am using Access 2k by the way

Hmm, I have only an Access 2003, but I'm sure A2K has it also:

Take a closer look at the Event page of the (sub)forms propertiy editor,
there should be an On Delete event...



mfG
--> stefan <--

 

[edisonl via AccessMonster.com]

Erm...

My subform had only on_click, even though I tried it on right-click
properties there is no event available as its rcordsource is blank.

 

[Stefan Hoffmann]

hi,

My subform had only on_click, even though I tried it on right-click
properties there is no event available as its rcordsource is blank.

Open your subform in Design View. Go to the menu: View/Properties.
Switch to the Event page. The list of events depends not on the Record
Source property.


mfG
--> stefan <--

 

[edisonl via AccessMonster.com]

Hi Stefan,

Yes I did tried it before.
It doesn't show much of event unlike other Subform Properties. I had a
subform without any record Source, Link Child, Source Object set when Subform
was created as rationale being multi-use the
subform from various table depend much on preceeding form choice.


Edison

 

[Stefan Hoffmann]

hi,

It doesn't show much of event unlike other Subform Properties. I had a
subform without any record Source, Link Child, Source Object set when Subform
was created as rationale being multi-use the
subform from various table depend much on preceeding form choice.

Na, you're on the subform control, not the subform itself.

mfG
--> stefan <--

 

[edisonl via AccessMonster.com]

Hi Stefan,

Erm.. Sorry I don't really get what you mean how do I know when I am in
Subform control/ Subform ?

Secondly, does your subform control here refered to those textboxes that
display table's fields ?

Your help is much appreciated..

Edison

 

[Stefan Hoffmann]

hi,

Erm.. Sorry I don't really get what you mean how do I know when I am in
Subform control/ Subform ?

As you're using A2K press F11, select the subform on the form page, open
it design mode. Open the property editor, select your form. Switch to
the Events page. There should be definitly more than an On Click event.
Maybe you can publish a screenshot somewhere.


mfG
--> stefan <--