Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sntax error in subroutine call 1

Status
Not open for further replies.

projecttoday

Programmer
Feb 28, 2004
208
US
I am getting a syntax error on a call to a subroutine in a module. This subroutine is called Entryloop. The call is in the on click event of the button on a form. The syntax error goes away when I remove the second parameter. (But I need the second parameter.)

This is how I call the subroutine. The call statement itself comes up red:

Dim startingDate As Date
Dim personId As Integer

Entryloop (startingDate, personId)

This is the first statement of the subroutine as it appears in the module modEntryloop:

Public Sub Entryloop(startingDate As Date, personId As Integer)

Anybody know why this is not working?

Is there a way to attach a database here?

Robert
 
Use either this:
Call Entryloop(startingDate, personId)
Or this:
Entryloop startingDate, personId

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top