Hiding a record

[nval005]

hello guys,

I just need some opinion about the code below:

tbl contains these:
uid
owner
private


uid=getOSUsername ' current user
txtOwner= thru SQL , retried owner of a particular record
txtPrivate= thru SQL, get value if owner set the record as private


if uid = txtOwner then
if txtPrivate="Yes" then
---show that advice (thru SQL)
else
---only show records that are not Private
endif
else ' if current user does not equal to the record's owner
--- do not show the advice
end if


i'm currently confused right now...i know how to retrieve the variables...but how will I only show the only allowed records for that particular user? and should I put this in the On Form open and then create a left and right arrow which contains this code so that it refreshes the data and only allow the owner of the advice

im confused... any comments on my pseudo code above? thanks in advance

 

[nval005]

ohhhhhhhh dont worry..it's now clear..............this always happens, I ask questions, then the light bulb goes..."DING !!!!" aha !!!!!! hehehe