Mike-
It's called a "combo box" because it's a combination of a text box and a
drop-down list. When you pick a value in the list, the value of the combo
box is the bound column from the entry you selected. You can provide a
combo box that lists all the usernames, and you can include the password in
the Row Source as a hidden column (Column Width = 0). Provide a text box
where the user can enter the password, and then write code to compare the
password column in the combo with what the user entered in the text box to
validate them.
--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/site/TR?pg=personal&fr_id=1090&px=1434411
Mike said:
I'm setting up a page that will let me control username/password. I would
like to have a combo box that will let me choose which username and the
corosponding password will apperar in a text box next to it. How is this
done? Is the text box binded to the combo box?
