application.caller?

[jluft]

i am using a group of control boxes to call a routine. depending on which control box calls the routine it will perform slightly different operations

to identify the control command button that called the sub i am trying to use
abc = application.caller
but this is returning an error msg (error 2023) to the variable rather than the name of the button

does anyone happen to know why this may be happening? thanks

 

[ZmrAbdulla]

See

http://www.fontstuff.com/access/acctut09.htm

Pass the Originator's Name to the Variable


________________________________________________________________________
Zameer Abdulla
Visit Me
A sweater is usually put on a child when the parent feels chilly.

 

[jluft]

zameer,
i am not sure how to do that. i thought i was doing it properly but i wasnt. i think i require some spelling out
isnt
abc = application.caller
an attempt at what you just said?

 

[jluft]

come out come out wherever you are

 

[GlennUK]

What kind of comand buttons have you got? I just did it with Forms toolbar drawn buttons and it worked fine.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[jluft]

glenn,
thanks...i am using a control button...i guess the two types would be control buttons (greater control over properties) and then forms which are the type taht ask whehter you want to assign a macro to them

i am using a control box and it is returning the error that i had mentioned. what line of code are you using?

 

[GlennUK]

oh right, Control buttons .... greater control over properties you say, erm, for a button, that would be what exactly? For my Forms button I used:

    MsgBox Application.Caller

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.