Vba Access 97 Help!!!!

Simply put I am trying to figure out where to begin this code, when I am trying to skip a record that another user is currently on...

I do not want to use the record locking, because that only does not allow the user to edit....I do not want the user to even see the same record as another user..(It's a long story)

I am in a bit of a jam..I was thinking of writing a logic statement that would check to see if the record was in edit mode, and then to skip that record, but I have been unsuccessful...do not know exactly what object to use...

ANY HELP?????

Thanks!

Well when a client opens a record you could log their current absolute position and skip that position for other clients.

VB Code:

Dim dbase As Database
Dim recset As Recordset
 
Set dbase = CurrentDb
Set recset = dbase.OpenRecordset("your query here", dbOpenDynaset)
 
If recset.AbsolutePosition = OtherClientPosition Then Gosomewhereelse
 
dbase.Close
Set dbase = Nothing
Set recset = Nothing