>>>>Is there a command to lock just a record so that noone else can modify or even look at this record?
>>>
>>>Take a look at Rlock().
>>>
>>>HTH
>>>Jeff
>>
>>Jeff, RLock() will prevent it's being changed, but not being looked at. I can't think of any command that won't allow a browse/Select/edit command.
>
>Is there any way to know whether the record is locked? Like a property or something? Even though they can view it I could tell them that it is read only or something!?
IF RLOCK()
* I just locked the record
ELSE
* Someone else has it locked
ENDIF
There is no way to prohibit someone for looking at the record.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer