Printing all record instead of just 1 with Access 365 Runtime

[rankhornjp]

Private Sub btnPrintReceipt_Click()
DoCmd.OpenReport "Payment Receipt", acViewNormal, , "id=" & Me.lstTransactions.Value
End Sub

This use to print just 1 receipt; the one selected in the "Transactions" table. I upgraded a computer and started using Office 365 and now it wants to print every transaction instead of just the 1.

Any ideas on what is causing this?


Thank you.

[orange]

If you are using 365, then please update your profile.
I saw a post recently with a similar issue where something that used to work was now not working. His solution was to restart Access.

[rankhornjp]

If you are using 365, then please update your profile.
I saw a post recently with a similar issue where something that used to work was now not working. His solution was to restart Access.

I use several different versions of Office and Windows. Your forum doesn't let me select more than one.


I have restarted the application and the computer several times.

[CJ_London]

Assuming it is not a MS bug, then something will have changed

Is your id field an autonumber or just a number that you calculate?

what is the rowsource to your listbox and what is the bound column?

I'm hinting that perhaps your transactions table does not have unique IDs as you would expect or that the bound column is bound to the PK of a transaction type (perhaps you changed the order of display but not the bound column)

[ranman256]

did you put stop on the line, and see what the value of: Me.lstTransactions.Value is?
is it correct?