Need to turn a VBA code into a Macro for Web Access 2010

[bmartinez3]

I have an web access dbase published, and need to secure the navigation form tabs based on the currentwebuser. The tabs which need to be secured on the form are as follows: cmdadminbutton; cmdTDbutton; cmdBASbutton. I also have following tables:

Users (fields: UserName, UserLogin, UserSecurity)

Security Level (field: Security Level) = ID 1 = Admin ; 2 = TD and 3 = BAS

I have a Login text field name "txtUser"

I want to do exactly this: https://www.youtube.com/watch?v=6GCTqYLTeH8

but, I can't use the VBA code that was created in the demo above since web access does not take code nor the DLookup function.

Here's what I came up with but I know its wrong, well because it doesn't work

attached is what i have started for the macro (don't laugh ) for cmdadminbutton (which is one of the tabs in the form.)

Please reply as soon as possible, thanks!!!!

[June7]

I don't think can use Me. prefix in macros. I think that is a VBA only syntax. Just drop the Me.

Cannot reference a table directly like that (Users). Must be a DLookup or the form must have the table in its RecordSource and then can just reference the field.

[bmartinez3]

June 7, thank you so much for your response. I will go ahead and move with your suggestions, hopefully that will take care of the trick. THANKS!

[June7]

I forgot to mention the form must be filtered to the single record. So I guess what you will have to do is take the user input and apply it as filter criteria to the form RecordSource. If the result is an empty dataset then the user input is not valid. This is truly brainstorming because I've never built web db.