S
Silver76
I have 19 fields in a table all in regards to information about photo images
In this table 4 of those fields are called ;
1=Keyword
2=2nd Keyword
3=3rd Keyword
4=4th Keyword
I also have a form which contains 4 fields also linked to the four fields in
the table.
The code for the combo box is as follows;
Private Sub Combo109_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[IRN] = '" & Me![Combo109] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
How do i make it search for single / multiple keywords in the 4 keyword
fields.
Part two
When it searches these records instead of returning the required records to
the the front of my form page, it takes the search to that individual record.
For example searching on cattle will take me to record 18 whereas i would
rather record 18 become record one and if multiple records become 1-2-3 of 22
instead of 8-14-22 of 22. Hopefully someone understands this.
In this table 4 of those fields are called ;
1=Keyword
2=2nd Keyword
3=3rd Keyword
4=4th Keyword
I also have a form which contains 4 fields also linked to the four fields in
the table.
The code for the combo box is as follows;
Private Sub Combo109_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[IRN] = '" & Me![Combo109] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
How do i make it search for single / multiple keywords in the 4 keyword
fields.
Part two
When it searches these records instead of returning the required records to
the the front of my form page, it takes the search to that individual record.
For example searching on cattle will take me to record 18 whereas i would
rather record 18 become record one and if multiple records become 1-2-3 of 22
instead of 8-14-22 of 22. Hopefully someone understands this.