VBA sub procedure has 2 parameters and no return value, but access says expecting =

Dev Articles Community Forums Sponsor:

March 22nd, 2005, 07:02 PM

helz

Registered User

Join Date: Mar 2005

Posts: 5

Time spent in forums: 1 h 24 m 30 sec
Reputation Power: 0

VBA sub procedure has 2 parameters and no return value, but access says expecting =

I have a sub procedure that has two parameters:

Code:

 Public Sub FieldState(obj As String, state As Boolean)
 	If IsObject(Me(obj)) Then
 		If state = True Then
 			Me(obj).Visible = True
 			Me(obj).Enabled = True
 		Else
 			Me(obj).Visible = False
 			Me(obj).Enabled = False
 		End If
 	End If
 End Sub

but when calling the procedure using:
FieldState("field", 0)
i get the error:
Expecting: =

However, I do not get this error with procedures that only have a single parameter.

Any Ideas?

March 23rd, 2005, 10:54 AM

pmcnamee

Registered User

Join Date: Feb 2005

Posts: 13

Time spent in forums: 1 h 12 m 52 sec
Reputation Power: 0

Remove the parentheses from the sub procedure call.

Code:

  FieldState "field", 0

insead of:

Code:

  FieldState("field", 0)

Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > VBA sub procedure has 2 parameters and no return value, but access says expecting =

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump