Search

[Beany]

Hi,

ive got 50% of the search engine working.................

i have a textbox and a bigger textbox underneath it. The bigger textbox shows 3 fields (provider, site, tel with the rest hidden) from my records,linked to my Query1

Query1 contains provider, site, postcode, tel etc etc

In my first textbox i can search by typing in the provider or site and it lists the appropriate details in the bigger textbox underneath it...........

i also have a reset button which i can click and it resets the bigger textbox and fills it with all the records..................

i need CODE and help............

underneath all this i want to have a form which fills automatically when i click the provider or site or tel in the bigger textbox.............? how do i do this...HELP

so if i click the provider, site or tel, it will bring up the rest of the details in the form below it!!!???????????

[Beany]

any1 have an idea?

thanks

[willakawill]

any1 have an idea?

thanks

Hi describing your code is not nearly as efficient as posting it. A picture paints a thousand words :)

[Beany]

Hi describing your code is not nearly as efficient as posting it. A picture paints a thousand words :)

Ok, heres the picture :) :

The code for the search textbox is:

Private Sub Search_Change()
 
Dim vSearchString As String
 
 vSearchString = Search.Text
 Search2.Value = vSearchString
 Me.QuickSearch.Requery
 
End Sub

The code for the reset button is:

Private Sub ClearIt_Click()
On Error GoTo Err_ClearIt
 
Me.Search = ""
 Me.Search2 = ""
  Me.QuickSearch.Requery
   Me.QuickSearch.SetFocus
 
Exit_ClearIt_Click:
    Exit Sub
 
Err_ClearIt:
    MsgBox Err.Description
    Resume Exit_ClearIt_Click
 
End Sub

I have a listbox named QuickSearch. This lists all the records:

its row source = Query1