Locking Records on replicated databases in both 2003 & 2007

[alathwell]

I would to provide the usr the ability to lock records on a form/subform. The database is distributed as a set of replicated databases some running in 2003 and others in 2007.
It seems that I can use the Setproperty statement in 2007, but it is not recognised in 2003. The benefit of this statement is that I can easily control the locked status of the subform and fileds on the main form on a record by record basis.
For example:
DoCmd.SetProperty "frmTransResourcesDetail Subform", acPropertyLocked, "-1"
DoCmd.SetProperty "Customer", acPropertyLocked, "-1"

Unfortunately 2003 does not seem recongnise this construct.

Can anyone suggest and alternate way of doing this.

 

[dfenton]

Why not just directly set the .Locked property? Something like this:

Me![frmTransResourcesDetail Subform].Locked = True

I can't fathom what purpose the A2K7 DoCmd.SetProperty statement serves -- why not just set the property directly?