Copying user input to a table

[neillovell]

Hello,
I have a query that asks for a user name and a password and it uses the password to sort some records.
What I'd like to do is to take the text the user enters as their user name, and put it into a table. How can I catch this string and log it?

 

[ladybyrd]

I haven't done this before, so I don't have any code at hand to pass on to you, but I do know that the Value property of the Parameter object will return the value you are looking for. Check Access Help under QueryDef and/or Parameters and/or Parameter Object.

HTH get you started..