running a sub

G

Ghell

ok, please dont delete this, i dont know where else to turn:( but it
isnt about excel, it is VBA in access (i dont know if there is any
difference) i have this:

Code:
--------------------

Private Sub DateBorrowed_AfterUpdate()
'get it to run Fine_GotFocus()
End Sub

Private Sub Fine_GotFocus()
'do stuff
End Sub
 
T

Tom Ogilvy

Assuming Fine_GotFocus is visible to DateBorrowed_AfterUpdate, this should
work.

Private Sub DateBorrowed_AfterUpdate()
Fine_GotFocus
End Sub

You might have to declare Fine_GotFocus as public instead of private

Public Sub Fine_GotFocus()
'do stuff
End Sub

if they are in different modules, you might need to preface with the module
name.
 
Top