Adding VB module to command button

[will1128]

I'm trying to understand how you can add VB modules to an Event in access. So far all I have seen add a macro to a command button upon an event.

If the name of my module was send_txt(), how do I add the module to the event?

I know you can add a command button, click on properties, events tab and then choose code builder, but it doesn't appear to do anything when I'm there.

I don't have any experience with VB, so this would be really helpful.

Thanks

 

[SteveSchapel]

Will,

I think you are talking agbout VBA, not VB. These are two different (but related) creatures.

When you "add a command button, click on properties, events tab and then choose code builder", then you should end up seeing something like this:

Private Sub TheButtonName_Click()
 
End Sub

It is in between these two lines that you write your VBA code.