password(field box) filter

[shy216]

i have a form which filters
stDocName = "frmFsource"
stLinkCriteria = "[StaffID] = '" & Me![cboStaffID] & "' And [AbID] = '" & Me![cboBud] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
and im trying to add another field. this one's little bit different since im not linking them from another form, instead a table.
"password".
i have a tblPassword with names of staffs and pws.
how do i make it so that when i double click from listbox
it'll check to match the pw from the tbl and the fieldbox(password) on the form?

 

[hwkranger]

Why are you trying to build your own password handling? Access has it's own project spaces with workgroups -- and user validation...

Randall Vollen
National City Bank Corp.

 

[PHV]

Have a look at the DLookUp function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[shy216]

hard to explain but.. the form consists of
3 combo boxes and a list box which updates after a
selection from above cbo box. i just wanted to add
a quick field box which can filter a pw since one of the cbo box already contains the staff name, when shifting to another form...