Find Record by two criteria 1

[din2005]

Hi all is it possible to bring up a record by 2 criteria's

e.g

' Set rs = Me.RecordsetClone
'
' stLinkCriteria = "Treatment_ID = " & Me.txtTREATMENT_ID
' rs.FindFirst stLinkCriteria
' Bookmark = rs.Bookmark

this shows how to bring up a record based on treatment id

How would i bring record for HospNo and Treatdate where hospno is a text.

Any suggestions ?

many thanks

 

[JerryKlmns]

stLinkCriteria = "Treatment_ID = " & Me.txtTREATMENT_ID & _
" AND HospNo =" & Me.txtHospNo