When query in SQL Server, the result as below
But when query in Access, it only show that first record correctly, and all other records are the same as first record as below
I just set the recordsource as below
I have other forms using the same coding to call data from SQL server, all works, except this one.Code:Me.RecordSource = "SELECT * FROM vDispenHistory WHERE PaNo='" & Me.PaNo & "' ORDER BY ReDate DESC"
Thanks