Hi,
I have created a form which emulates a split form following the example database found here
This works fine however when I am trying to implement a search function with the following code I get one match in the text box's but the continuous form does not filter to show if there are multiple matches (Ie it shows all records)
Can anyone help?
I have created a form which emulates a split form following the example database found here
How to Emulate Split Form
I've been using split forms for some time now with the datasheet on the left and the single form part on the right. I find many small annoyances with split forms. I want to emulate them using a continuous form as a subform of a single form with the single form based on the same table as the...
www.access-programmers.co.uk
This works fine however when I am trying to implement a search function with the following code I get one match in the text box's but the continuous form does not filter to show if there are multiple matches (Ie it shows all records)
Code:
Me.SearchItem.SetFocus
Me.FilterOn = False
Me.Filter = "[SearchItem] Like '*" & SearchItem & "*'"
Me.FilterOn = True
Me.Requery
Can anyone help?