Query - Search Engine

[icemac]

I would like to create a query where I can search my selected fields on a particular field. However I do not want to do this in the standard way. I would like the query to appear in a 'search engine' type format (like a form but with a search). Is this possible????

 

[michellerobinso]

sounds like you need something like this

 

[icemac]

Ye like this. I tried the code you used when looking at the deign view on query but this did not work when i was using fields from two different tables. Can you help?

 

[michellerobinso]

can you post a sample of what you are working on?

 

[Rylinkus]

This is a really nice little form. I was wondering if someone could explain to me why when you click on the search results it yields a message box thats says "Could not locate [Date]", where date is the date of the row clicked on. The relevance of this is that when I tryed utilizing a similar setup in my DB I dont get a messagebox like that but a syntax error instead which tellings me Im not fully understanding what's going on and I was hoping someone could shed some light on it for me.

Private Sub QuickSearch_AfterUpdate()

DoCmd.Requery
Me.RecordsetClone.FindFirst "[Number] = " & Me![QuickSearch]
If Not Me.RecordsetClone.NoMatch Then
Me.Bookmark = Me.RecordsetClone.Bookmark
Else
MsgBox "Could not locate [" & Me![QuickSearch] & "]"
End If

End Sub