I have a form that is Unbound that is a search form. (based on this: http://www.access-programmers.co.uk/forums/showthread.php?t=188663
SearchTXT is Hidden
SearchFor field has for the OnChange:
'Create a string (text) variable
Dim vSearchString As String
'Populate the string variable with the text entered in the Text Box SearchFor
vSearchString = SearchFor.Text
'Pass the value contained in the string variable to the hidden text box SrchText,
'that is used as the sear4ch criteria for the Query QRY_SearchAll
SrchText.Value = vSearchString
'Requery the List Box to show the latest results for the text entered in Text Box SearchFor
'Tests for a trailing space and exits the sub routine at this point
'so as to preserve the trailing space, which would be lost if focus was shifted from Text Box SearchFor
If Len(Me.SrchText) <> 0 And InStr(Len(SrchText), SrchText, " ", vbTextCompare) Then
'Set the focus on the first item in the list box
Me.SearchResults = Me.SearchResults.ItemData(
'Requery the form to refresh the content of any unbound text box that might be feeding off the record source of the List Box
'Returns the cursor to the the end of the text in Text Box SearchFor
If Not IsNull(Len(Me.SearchFor)) Then
Me.SearchFor.SelStart = Len(Me.SearchFor)
There is a qry that is setup for the searching on the field : SearchResults
What I want to do is once I select a record in the search results, have that record come up in another form or within the same form.
How can I do this?
Sorry I haven't responded sooner, but the Easter Holiday put me away for a while with the family.