Difference between load and open

[Helen]

I'm not exactly sure what kinds of things to put in these two procedures.

What kinds of things should go into LOAD, and what into OPEN?

[NoellaG]

Hi, a form, the following events occur in this order:

Opening a form triggers first the open event, then the load event when the data are shown, then the activate event is triggered and then the first record becomes the current record and triggers the OnCurrent event
The open event can be canceled, the load can't
So if you want to cancel the opening of the form when no records available, you'll have to use the onOpen.

hope this helps a bit

NG

[Helen]

Noella - thanks, yes it does help.