Dlookup with multiple criteria??

[deb]

access2003

How can I make the textbox field"PassedQGDt" on form f015KeyMilestones"
enabled if MSPContactUserID=Environ("username") and the MSPTitleID=8 (number)

Check the Environ("username") against the MSPContactUserID and the
MSPTitleID=8

The user can have many MSPTitleID's ( it is a role table) and user can have
many roles, so it must search the table for both criteria and not just the
first MSPContactUserID .

Table is "t41ContactsMSP" (PK-MSPContactID number). Table set up like...

MSPContactID.............MSPTitleID.............MSPContactUserI
1.......................................1................................abcab
2.......................................1................................defde
3.......................................8................................abcabc


Your help us very appreciated!!!

 

[Dirk Goldgar]

access2003

How can I make the textbox field"PassedQGDt" on form f015KeyMilestones"
enabled if MSPContactUserID=Environ("username") and the MSPTitleID=8
(number)

Check the Environ("username") against the MSPContactUserID and the
MSPTitleID=8

The user can have many MSPTitleID's ( it is a role table) and user can
have
many roles, so it must search the table for both criteria and not just the
first MSPContactUserID .

Table is "t41ContactsMSP" (PK-MSPContactID number). Table set up like...

MSPContactID.............MSPTitleID.............MSPContactUserID
1.......................................1................................abcabc
2.......................................1................................defdef
3.......................................8................................abcabc


Your help us very appreciated!!!

If I've understood you correctly, this would do it:

Me.PassedQGDt.Enabled = _
Not IsNull( _
DLookup( _
"MSPContactID", _
"t41ContactsMSP", _
"MSPTitleID=8 And MSPContactUserID=""" & _
Environ("username") & """" _
) _
)