Search results

There's the VBA code I've found Private Sub cmdSearch_Click() On erorr GoTo errr Me.propertyTBL_subform.Form.RecordSource = "SELECT * FROM propertyTBL " & BuildFilter Me.propertyTBL_subform.Requery Exit Sub errr: MsgBox Err.Description End Sub Private Function BuildFilter() As Variant Dim...

Novice alert!! Thanks for helping me... I've found some code that I've use... it seems don't work! - There are an other thing that I need in my projet, it's when I search for a record if the search form didn't find it I want that a msg box will pop up with a [No Record Message]

I'm novice in access 2007 I've a project that contain a Table a form with Subform bound to that table, on tthe main form I've unbound [text boxes] and a [search button] I want that my form act as a search form , so when I click the search button it show the only result an that table subform...