Missing Event

[BBinMO]

Hello,

I have just joined this forum so I apologize if this question has already been asked, although I did do a search first. Here is my question:

I'm reading the Microsoft Press book, "Microsoft Access Version 2002, Inside/Out" by Helen Feddema. On page 846, in talking about how to use Form Event Procedures, she shows how to open a form's object property then click on the event tab so that you can enter code for the appriate event procedure. Her event tab of the form properties sheet shows more events than my pc does for Access 2002 (my Access help shows I'm running version 2002). Her event tab starts with "On Current" then "Before Insert", "After Insert" then "Before Update" while mine starts with "Before Update". She shows many more events than what my PC has and I need to use some of the missing ones. Anybody have an idea what's wrong or what I have to do to get the missing events to show up on my PC?

Thanks,
BBinMO

 

[tjs206]

Hi BBinMO,

I wouldn't be to concerned with those events not being on the property sheet of your form. Even though they aren't there doesn't mean you can't use them. For example, go to your form design toolbar, then click on the 'Code' button. This opens up your VBA editor from there you can type in your own functions.

Like:

Private Sub cmbSalesManName_OnCurrent()

Once you type this line and hit enter, Access automatically creates your End Sub line to encompass your function.


Even though the event doesn't exist visually in your forms properties, which I am not exactly sure why it doesn't (Is this an upgrade to Access XP?), don't be to concerned because you can still use the events that you need, just to do it programmatically.

Hope this helps.

 

[RV]

Her event tab starts with "On Current" then "Before Insert", "After Insert" then "Before Update" while mine starts with "Before Update".

That's because you're looking at a different section of your form in design mode.
Helen refers to the form events.
Click in the little square on top left of your form in design mode et voila!

RV