query following listbox selection (1 Viewer)

[sagey]

hello

im working on a form where the user selects a company name from a listbox. the user is then asked to enter a password.
if the password is correct i then want access to return all the other users that are under that company name

obviously i guess i have to write an event handler for the listbox that makes the textbox visible when a company has been selected and then an event handler that says
if text = password then
run query
but how do you put variables into an sql statement (because it could be any of the companies that will be selected.

i hope this makes sense
i am only a beginner and this is my first proper db so if anyone could point me in the right direction i would be most grateful

cheers

 

[Alexandre]

See if that thread helps you. If no chance, re-post.Open a recordset based on a parameter from a form