Search results

Sorry Bob Im not good at expaining things like this Thx Roy, I understand your answer. Havnt tried it yet but i get the principle.

Sorry one of us misunderstood Variable = Me.ControlName - Wouldnt this change my variable? and I dont know what the control name is I want to use the variable to say which control I am changing Maybe I should of stated the variable is the control name

Me.ControlName = Variable Ok, I know how to do that, but I want to do is Me.Variable = Whatever Can this be done, if so how?

I sorted my problem, I had to learn the DLookup function, I assume the same will work for you. I wont try and tell you how to do it, I dont understand the syntax properly yet, why is it square brackets there and quote marks there!!! :confused: oh well, at least it works :cool:

Bob, I know I'm a noob but to my knowledge you have to use code OR a macro, You cannot put code IN a macro Sorry if I'm wrong but I am here trying to learn :)

OK the original post is a bit hard to read but he does say which bit he is struggling with "[password]![password]" He wants that bit to be "Password from password table where student number equals selected student number" I dont know how to add filters to this sort of expression, I am trying...