ohk, sweet. thanks. i eventually did something similar to that to get it to work.
Definitely removed the DLookup
If UserID = "4" Then
Me.AddForm.Enabled = False
Me.EditRecords.Enabled = False
Me.PQueries.Enabled = True
Me.Tile_Price_Check.Enabled = True
Me.Supplier_Items.Enabled = True...
Hey.....
I'm pretty much stuck in a rut for an assignment here. Could really use the assistance. Pretty much i wanna get a particular permission set to the user "Clerk" that when the main menu comes up, two buttons are disabled preventing them from writing to the DB. so this is wat i have thus...