Store Select Statement as Variable??

[sedixon]

Is it possible to store a select statement as a variable?

I have a table (UsysPassword) with a single row (Password). I would like to be able to select this row and store it as a variable to compare with another text box.

As you can probably guess, I want to make sure what the user enters as a password matches the existing password. I would like to keep it as a table so that I can create a form to update the existing password.

Any ideas?
Thanks so much!
Sarah

 

[thornmastr]

If your table has only one column (password), how are you associating a particular password with a particular user?
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[sedixon]

I'm not.... (yes I know, not the best security).

I only needed a password to protect the raw data. I figured out a way using Dlookup to verify the password.

Thanks!