Avatar of Larry Brister
Larry Brister
Flag for United States of America asked on

MS Access 2003 Subform event

I have a main form (datsheet view) and a subform(also dataseheet view)

Lets say I expand the main form and then expand the subform

When I now click OFF of the subform by clicking in the main form...what event is that?

Form unload?
Lost Focus?
Microsoft AccessMicrosoft DevelopmentMicrosoft Applications

Avatar of undefined
Last Comment
Jeffrey Coachman

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Jeffrey Coachman

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Larry Brister

ASKER
JeffCoachman

I'll take a look at that from home tonight.

Believe it or not...they cut us some slack and the programmers can leave an hour early today!
Jeffrey Coachman

<they cut us some slack and the programmers can leave an hour early today>
I'm in NY and I have to stay 15 more minutes till 5PM...
Larry Brister

ASKER
Thanks
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Jeffrey Coachman

Just to be clear, what was the solution here?
Larry Brister

ASKER
boag2000

You just gave me a clearer understanding of the process.

I placed a messagebox on every type of event and walked my way through a series of issues. (Inherited)

This database has a load of VBA that switches back on itself and I'm removing duplicate code.
Jeffrey Coachman

OK great.

Yeah, the Messagebox trick is what I use to look at all the events and when they fire, and under what circumstances.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.