Subroutine Error

[TimGoff]

Hi,

Please see sub below...when I attempt to write in my code the line...

UpdateProgRights (RstRights, True)

...I get an expected:= error

I can't see what is wrong! Anybody any ideas?

Thanks
Tim

Sub UpdateProgRights(rstRecordset As Recordset, blnNoRightsExist As Boolean)

With rstRecordset
.AddNew
!TerritoryID = Me.cmbTerritory
!ThirdPartiesID = gintThirdPartyChosen
!NoRightsExist = blnNoRightsExist
.Update

End With

rstRecordset.Requery

End Sub

 

[KenReay]

Hi

Well it should be

UpdateProgRights RstRights, True

you only use () with functions

Regards


Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use

 

[TimGoff]

Cheers Ken

Knew it would be something very simple like that

Tim