How do you use an event property for a form?

[Access_Novice]

I understand how to use the events of a form. In the property sheet, click the Events tab, select the event you want, click the builder button, and type your code into the sub routine that appears.



But let's say you want to use a form property that is associated with an event, such as:

Me.BeforeInsert

Where would you type this code in? From what I gather, it would be

Me.BeforeInsert = procedureName

I am trying to find out:

1. Where would you actually type this code? Please outline the steps.
2. Please show an example where a macro is invoked.
3. Please show an example where an event procedure is invoked.

[BRZ-Ryan]

In the visual basic editor.. you can access all form events there

[Access_Novice]

In the visual basic editor.. you can access all form events there

Ok now I "see it." In Excel VBA you can type code in a module, and when doing that, you can change the property for an object, such as a worksheet object. In Access VBA I see that you can also add a module there as well, and then simply refer to the object in question and change its properties. Now I get it.

Thank you. I'm still trying to understand the "big picture" but now I think I see a lot more of it.

[Access_Novice]

In the visual basic editor.. you can access all form events there

I don't see any icons to wrap tags around code.


What about this? I have this code in Module 1. I get an error saying "can't find object 'message.' " I am trying to say when I start typing a new record into the form called "Gymnast" the message box in the second procedure should be triggered.

Sub testingForms()
Forms!Gymnast.BeforeInsert = "[message]"
End Sub

Sub message()
MsgBox "This is a test of the BeforeInsert property"
End Sub

How would I get this to work? Would I have to put the cursor in the first procedure, then press F5 in the VB Editor, then go back to my form and test it by adding a new record?

Or would I just go right back to the form and the code would automatically be invoked? In short, what do I have to do to trigger this code.

[BRZ-Ryan]

VBA doesn't work with code tags. You place code in the event where you want it to fire.. Play around with form_current, and try the condition :

if me.newrecord then
Msgbox "hi"
End if

[Access_Novice]

VBA doesn't work with code tags.

When I said tags, I was referring to tags to put around my code example in my post above.

[June7]

Go to the Advanced post editor. Click button below the quick reply post editor.

Can type them once you become familiar with them.