proffittware
asked on
Access Events that occur on a form during different actions
I need to know which actions occur on a form.
I know that when a form is opened: the order of events are Open, Load, Resize, Activate and Current.
When a form is closed: the order of events are Unload, deactivate, Close
What are the events that occur when using a button with (Next): DoCmd.GoToRecord , , acNext
Or a button with (Previous): DoCmd.GoToRecord , , acPrevious
I know that when a form is opened: the order of events are Open, Load, Resize, Activate and Current.
When a form is closed: the order of events are Unload, deactivate, Close
What are the events that occur when using a button with (Next): DoCmd.GoToRecord , , acNext
Or a button with (Previous): DoCmd.GoToRecord , , acPrevious
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thenelson...
I have a form (with subforms) that I do not want the delete button (X) available except through a Delete button (command-AllowDeletions) I have created. I have many created command buttons for Add, Edit, Next, Previous etc. I needed to know the different events to make sure that I placed the AllowDeletions = False in the correct events.
I have a form (with subforms) that I do not want the delete button (X) available except through a Delete button (command-AllowDeletions) I have created. I have many created command buttons for Add, Edit, Next, Previous etc. I needed to know the different events to make sure that I placed the AllowDeletions = False in the correct events.
Fair enough.
BTW: The form's Before delete confirm event will capture the built in delete button so You can do what you want with it.
BTW: The form's Before delete confirm event will capture the built in delete button so You can do what you want with it.
ASKER
thenelson:
<<Before delete confirm event >>
what and where are you referring ?
If I understand your explanation, that is what I have wanted to do...program the toolbar delete.
<<Before delete confirm event >>
what and where are you referring ?
If I understand your explanation, that is what I have wanted to do...program the toolbar delete.
ASKER
I found BeforeDelConfirm...thanks I will keep that in mind.
ASKER
Thanks to everyone that responded...all the information was great ...sending me in the correct direction.
<<Before delete confirm event >>
what and where are you referring ?
I know you found it but I just created this:
Form-Events.gif
what and where are you referring ?
I know you found it but I just created this:
Form-Events.gif
"Grade: A - "Thanks to everyone that responded...all the information was great ...sending me in the correct direction." "
You are welcome.
mx
You are welcome.
mx
ASKER