|
|
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
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200812/1
|
|
hi Edison,
edisonl via AccessMonster.com wrote:
[Quoted Text] > - 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 <--
|
|
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 wrote:
[Quoted Text] >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 <--
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200812/1
|
|
hi,
edisonl via AccessMonster.com wrote:
[Quoted Text] > 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 <--
|
|
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 wrote:
[Quoted Text] >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 <--
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200812/1
|
|
hi,
edisonl via AccessMonster.com wrote:
[Quoted Text] > 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 <--
|
|
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 wrote:
[Quoted Text] >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 <--
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200812/1
|
|
hi,
edisonl via AccessMonster.com wrote:
[Quoted Text] > 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 <--
|
|
|