FormQuery

[June7]

Sorry, suffering head cold for 2 days. Not thinking clearly.

If DLookup("AccessLevelID", "tblAccess", "UserID='" & lUser & "'") <> 1 Then
If IsNull(DLookup("UserID", "tblAccess", "CategoryID=450 AND UserID='" & lUser & "'")) Then

[Sheba]

already Step debugged and variables are set. where multiple catIDs are assigned to a userID, DLookup is pulling only the first value. I want to reference categoryID in tblAccess directly because it occurs uniquely.

[Sheba]

oh just seen your last post. I'll read up and post appropriate update.

Thanks

[Sheba]

June7 sorry to hear about your cold. hope you feel better soon and also hope I'm not worsening it for you
I'm abit confused by your lastpost. what would this part be referring to...?

AND UserID='" & lUser & "'"))

[Sheba]

I get it! criteria is, userID for the specific CategoryID should be same as user's loginID. It has worked for one user who has multiple forms to access. Thank you very much. I'll try on the others. Should work.

[Sheba]

I also took out the apostrophe

[Sheba]

yup tis working thanks again June7