List for Event order?

[Ron]

Hi all

Just wondered if there's a list somewhere that explains when the events on
forms, reports, etc fire. I'm looking for the order of things. Like, the
first event to fire when a new form is opened is 'a'. Then, 'b' is
activated. So I'd have a=>b, etc. And when does the actual data pop into
the form from the underlying table. That kinda thing.

Also, need the same thing for when things happen for a control on a form,
etc.

Is there a handy dandy reference someone can point me to? A book that would
itemize this sort of thing? I've checked the Access2000 help file and if
it's there I can't find it. I've bought some elementary books on the
subject--no such listing. Sure, there's some explanations, but no roadmap
with that kind of detail. See, I know I can put a routine in On Load, or On
Current...but which happens first, then second, then if this happens, this
other thing fires? I've tried experimenting and I seem to be either too
early, or too late. (Story of my life...)

Thanks in advance for any help anyone can offer.

ron

[PC Datasheet]

This book has it:
AccessXXX Developer's Handbook, Getz et al, Sybex
Where XXX is your version of Access

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Ron" <ro*******************@earthlink.com> wrote in message
news:X5***************@newsread1.news.pas.earthlin k.net...

Hi all

Just wondered if there's a list somewhere that explains when the events on
forms, reports, etc fire. I'm looking for the order of things. Like, the
first event to fire when a new form is opened is 'a'. Then, 'b' is
activated. So I'd have a=>b, etc. And when does the actual data pop into
the form from the underlying table. That kinda thing.

Also, need the same thing for when things happen for a control on a form,
etc.

Is there a handy dandy reference someone can point me to? A book that would itemize this sort of thing? I've checked the Access2000 help file and if
it's there I can't find it. I've bought some elementary books on the
subject--no such listing. Sure, there's some explanations, but no roadmap
with that kind of detail. See, I know I can put a routine in On Load, or On Current...but which happens first, then second, then if this happens, this
other thing fires? I've tried experimenting and I seem to be either too
early, or too late. (Story of my life...)

Thanks in advance for any help anyone can offer.

ron

[Allen Browne]

See:
Understanding Event Order in Microsoft Access 2000
at:
http://support.microsoft.com/?id=208781
The article gives you a download (orders.mdb) that contains ShowEvents and
EventHistory.

The crucial form events are are:
1. Open occurs first. You can cancel the open, or assign a RecordSource
here.
2. Load occurs next. Assign values to controls here.
3. Current occurs next, and then every time you move record.
4. The form's BeforeUpdate fires before the record is saved. Use this for
record-level validation.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ron" <ro*******************@earthlink.com> wrote in message
news:X5***************@newsread1.news.pas.earthlin k.net...

Hi all

Just wondered if there's a list somewhere that explains when the events on
forms, reports, etc fire. I'm looking for the order of things. Like, the
first event to fire when a new form is opened is 'a'. Then, 'b' is
activated. So I'd have a=>b, etc. And when does the actual data pop into
the form from the underlying table. That kinda thing.

Also, need the same thing for when things happen for a control on a form,
etc.

Is there a handy dandy reference someone can point me to? A book that
would
itemize this sort of thing? I've checked the Access2000 help file and if
it's there I can't find it. I've bought some elementary books on the
subject--no such listing. Sure, there's some explanations, but no roadmap
with that kind of detail. See, I know I can put a routine in On Load, or
On
Current...but which happens first, then second, then if this happens, this
other thing fires? I've tried experimenting and I seem to be either too
early, or too late. (Story of my life...)