running modules

Posted by Andy Evans on November 14, 2001 2:17 AM

I have a module called findjw()
and I want to run it upon choosing something from a combobox

I have written this but I don't know the code to call the module

help

Private Sub CommandButton1_Click()
If ComboBox1.Value = "junior wheelchair" Then
Run (findjw)

End
End If
End Sub

Posted by Dank on November 14, 2001 2:24 AM

You don't need to use Run. You can just name the procedure that you want to run i.e.

Private Sub CommandButton1_Click()
If ComboBox1.Value = "junior wheelchair" Then
findjw
End
End If
End Sub

Hope it helps,
Daniel.