I have been battling over this for more than 6 hours now...
On a report I have a Text Box named 'MyTextBox'
Next to it a button with a caption 'Go'
What I would like is for the user to type in a Surname of a customer and the report filters all records for that surname.
On the button I have the following code:-
Dim strFilter As String
strFilter = "[Surname] Like """ & Me![MyTextBox] & "*"""
DoCmd.OpenReport "CustomerRecords", acViewReport, , strFilter
However at the moment whatever is typed into the Text Box displays all records...