quickone

[peterbowles]

Any idea why this code will not work

Me.RecordSource = "select [StudentNumber] from [Add/ViewStudents] where [Studentnumber] like '*" & Me!txt1 & "*'" Or "select [Postcode] from [Add/ViewStudents] where [Postcode] like '*" & Me!txt2 & "*'"

Thanks

 

[Mile-O]

No guarantees it'll work but I tidied your SQL:

Me.RecordSource = "SELECT [StudentNumber], [Postcode] FROM [Add/ViewStudents] WHERE (([StudentNumber] Like '*" & Me!txt1 & "*') OR ([Postcode] Like '*" & Me!txt2 & "*'));"