cannot show SQL query correctly

[uoghk]

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

Me.RecordSource = "SELECT * FROM vDispenHistory WHERE PaNo='" & Me.PaNo & "' ORDER BY ReDate DESC"

I have other forms using the same coding to call data from SQL server, all works, except this one.

Thanks

[Gicu]

You set the recordsource where? Where is Me.PaNo? Do you requery? Show us some more info to get pertinent answers.

Cheers,

[uoghk]

I first set RecordSource="select * from vDispenHistory" on Property Sheet.
In Form_Open, I set Me.RecordSource="SELECT * FROM vDispenHistory WHERE PaNo='" & Me.PaNo & "' ORDER BY ReDate DESC"
Then I set Me.Requery just after Me.RecordSource.
Then Me.PaNo is '10606' as shown in photo 1.

[uoghk]

In SQL Server, the query shows 19 records.
Because I use the same PaNo '10606', it is expected to show 19 records in the form.

[uoghk]

Thanks Gicu's help to evaluate my case.

[Welshgasman]

I first set RecordSource="select * from vDispenHistory" on Property Sheet.
In Form_Open, I set Me.RecordSource="SELECT * FROM vDispenHistory WHERE PaNo='" & Me.PaNo & "' ORDER BY ReDate DESC"
Then I set Me.Requery just after Me.RecordSource.
Then Me.PaNo is '10606' as shown in photo 1.

If you change the recordsource, no need for Requery.
You are effectively doing it twice.

[Welshgasman]

Thanks Gicu's help to evaluate my case.

So what was the issue?
Remember these forums are to help other people, not just yourself.

[Gicu]

Can you try to move the code to the form's load event instead?

Cheers,