Search Button in a Form

[gaby58]

Hi All,



I have 3 fields in a form which is coming from a table, I want add a text box and then a search button, when they enter the value of the first field in the text box and click search all the related data should be displayed in those 3 fields, how do I do that.

I did use Seach button and a macro, but didn't work, it is kinda urgent so any help is appreciated.

Thank You

[ranman256]

Make a continous form of your data table.
put the search box and button in the header.
when user types in the text box , it will filter the results.

(since I dont know what field you are searching in, i set it to CITY)

paste the code below into the BUTTON CLICK event:

sub btnFind_CLICK()
If IsNull(txtBox) Then
  Me.FilterOn = False
Else
  Me.Filter = "[City]='" & txtBox & "'"
  Me.FilterOn = True
End If
END SUB

[gaby58]

Is it not possible to get it directly from a table or a query to populate these values?

Thank You for the info though

[June7]

For more info, review http://allenbrowne.com/ser-62.html