Shipper225
Windows XP Access 2007
- Local time
- Today, 01:21
- Joined
- Jun 23, 2011
- Messages
- 69
So I've managed to use a search form that was posted on here but I am having a problem being able to search based on the displayed results of a combo box. I am trying to have a field search the second column of the combo box but I don't know the code to do so. To simplify the question here, is there a way I can use the search function that I built to find only the results based in column two (the displayed field on the search form) here is the code I am currently using:
Right now all it lets me do is search but the first column the primary key Inventory.ID and not what I need Inventory.Item
Code:
'Item Search.
If Not IsNull(Me.cboItem) Then
strWhere = strWhere & "([Transaction Item] Like ""*" & Me.cboItem & "*"") AND "
End If
Right now all it lets me do is search but the first column the primary key Inventory.ID and not what I need Inventory.Item