Hello,

I have a Table with the following Data

Table name: TilesEquipment

Field 1
Tile : 8a (there are 45 occurances of each tile position or 8a * 45 Tile Positions examples 8b, 8c, 9a, etc..)

Field 2
Ru: 45 (This number ranges from 1 to 45)

Field 3
Equipment: server (This field is populated with what equipment is in it)


I have set up a search on a form like this.

Text Box: tSearchCriteria1
Text Box: tSearchCriteria2
Button : Search01
Text Box: tSearchResults45

Private Sub Search01_Click()
Me![tSearchResult45] = DLookup("[Equipment]", "TilesEquipment", "[Tile] = '" & Me![tSearchCriteria1] & "'")
End Sub


This works fine for one Criteria (Tiles eg. 8a)


Is there a way to add another Criteria into this.

Example: add tSearchCriteria2 that would look at the Ru field in the Table and return the value of Equipment if it matches both Tiles(tSearchCriteria1) and Ru(tSearchCriteria2)


Thanks in Advance.