Help with security form

[Anauz]

Hi All

I am creating a security form for my db. What i want to know is can you take the value out of a txtbox, and place it in the "where" statement of embedded sql?
Before anyone asks why don't i use access's security wizard.....i have and it works fine. The problem is that the db is going to be accessed via the local network...and some users won't have access on thier machines....and are loading it via a terminal server. This means they can't use the db because of the check i have put in it to see it they are using the correct workgroup file.....phew!

any help is greatly apprecieated

Anauz

 

[llkhoutx]

yes, build the where with the contents of the textbox. Check your syntax via a query.