byref and byval

[cisy]

I would like to know if Access VBA has the similar feature as VB in terms of passing parameters with byref and byval. In the following sample program, the value is changed to true in the sub but when it is passed back to the calling program, it still carries false.

In the calling program:

dim blnDeleted as boolean
blnDeleted = false
ChkIfDeleted(blnDeleted)
msgbox blnDeleted

...
...
...
end sub

public sub ChkIfDeleted(byRef blnDel as boolean)
...
...
...
blnDel = true
msgbox blnDel
end sub

[HansV]

The line

ChkIfDeleted (blnDeleted)

passes blnDeleted as a ByVal argument because you enclose it in parentheses. You should use either

ChkIfDeleted blnDeleted

or

Call ChkIfDeleted(blnDeleted)

[ChrisGreaves]

... because you enclose it in parentheses.

Good call!

[cisy]

Thanks Hans. Clearly it is different from VB.