G
Guest
Good afternoon all,
I get an error stating "Expected Function or Procedure, not module"
when I try to call a Public Function it using a command button.
If Not IsNull (Me.Staff_ID) Then
Call GetCarryOver(Me.Staff_ID) 'Call this function, send Me.Staff_ID
Else
MsgBox "Select a staff member.", vbOKOnly
Me.Staff_ID.SetFocus
End If
The first line of the Function is:
Public Function GetCarryOver(Staff_ID As Long) As Long
I'd appreciate any guidance!
Renee
I get an error stating "Expected Function or Procedure, not module"
when I try to call a Public Function it using a command button.
If Not IsNull (Me.Staff_ID) Then
Call GetCarryOver(Me.Staff_ID) 'Call this function, send Me.Staff_ID
Else
MsgBox "Select a staff member.", vbOKOnly
Me.Staff_ID.SetFocus
End If
The first line of the Function is:
Public Function GetCarryOver(Staff_ID As Long) As Long
I'd appreciate any guidance!
Renee