Macro Action Arguments

[myxmaster]

I have the following in the macro argument fields.

Open Form = Transaction Query
View = Form
Filter Name = Credit Transactions
Where Condition = [ID]=[Forms]![Accounts]![PlayerID]

The object is to show only the credit records that match the player
ID. All elements of the macro work except it shows all credit
transactions as opposed to individual. Any advise is most appreciated.

TIA

 

[Larry Linson]

I have the following in the macro argument fields.

Open Form = Transaction Query
View = Form
Filter Name = Credit Transactions
Where Condition = [ID]=[Forms]![Accounts]![PlayerID]

The object is to show only the credit records that match the player
ID. All elements of the macro work except it shows all credit
transactions as opposed to individual. Any advise is most appreciated.

Does the Field "ID" in the transactions data that is Record Source of Form
Transaction Query represent the PlayerID as displayed in the PlayerID
Control of Form Accounts? Is Form Accounts Open? Is a PlayerID selected?

Larry Linson
Microsoft Access MVP