Search Function- results displayed in same form as submit

[andyt_2005]

Hi All, Firstly let me say thanks for the posts that have helped me and sorry if i have posted this in the wriong place.Been using a few posts on here to try and help my issue but no luck as of yet. Im trying to use a text box and button to perform a search function in the same form as the data was input. The Db is basically a fault tracking DB so the input will save the fault as open then when i want to close it i use a search box in the header to search for the 'fault Number' and display the results in the same formI have tried so many solutions but as of yet im at a blank. Any help will be greatly welcomed by anyone! I have attached a pic of my form (DB is too big) so you can see what im talkin about

[pbaldy]

One way would be to reset the form's record source property:

Me.RecordSource = "SELECT * FROM TableName WHERE KeyField = " & Me.TextboxName

[andyt_2005]

This is the search funtion im using at the moment. However this is throwing up all sorts of errors! I am a complete Noob when it comes to Access! Excel im fine But its something about this programme! Where in this would i put that code?Private Sub Search_Click() If IsNull(txt) = False Then Me.Recordset.FindFirst "Faultnumber=" & txt Me!txt = Null If Me.Recordset.NoMatch Then MsgBox "No record found", vbOKOnly + vbInformation, "Sorry" Me!txt = Null End If End IfEnd Sub

[pbaldy]

The answer to where you would put the code:

http://www.baldyweb.com/FirstVBA.htm

[andyt_2005]

No Joy with this, Im thinking It would just be easier to make another form ansd somehow pull all the details up in that one. . .

[pbaldy]

Your code is hard to read like that, but I'd expect it to set a bookmark. Two links here that may be of interest:

http://www.baldyweb.com/wherecondition.htm