I am soooo confused. When you click from button to button, the transactions sort properly, which is great. Then you close it and Double Clicked On Checking 1.
After Double Click - Shows Checking 1 - Record 1 of 13 (Deposit) - Cleared (1635.04) - Running (-171.01)
You Click SortAZ - Shows Checking 1 - Changes to Record 1 of 18 (Aqua) (13 to 18) - Cleared Amount Changed (2453.04) - Running (-171.01)
You Click SortZA - Combo Changes to Checking 2 - Record 1 of 18 - Cleared (2453.04) - Running (-171.01)
You Click SortAZ - Combo Changes to Checking 1 - Record 1 of 18 - Cleared (2453.04) - Running (-171.01)
You Click Back and Forth a Few More Times - Combo Changes Back and Forth from Checking 1 to 2
My Understanding - Transactions Displayed Should All Be From Checking 1 --- Should Show Records 1 of 13 (I Think) --- 5 Transaction are from the other Account & Shouldn't be displayed
- Totals Shouldn't Change --- They should all be the same transactions --- Just sorted differently
What am I missing? Is this a bug, or am I understanding how this is supposed to work incorrectly?
I checked the bug fixes, but didn't see this mentioned anywhere.
I checked the download, and it is doing the same thing. 7 Transactions Total (2 + 3 + 2) - Starts off showing 2 transactions and then goes to 7, different totals, different accountcombo display.
Adam Schwanz
@Reply 4 years ago
Sorry Richard, i caught this a while ago when working for someone and never mentioned it. Requerying drops the filter
You can fix it by changing the code on the requery form sub, you can replace the calling from other form with an unbound invisible field if you want
Me.RecordSource = "SELECT * FROM CheckRegQ where AccountID=" & Forms!CheckRegMenuF!AccountList & W & O
and changing this line
If W <> "" Then W = " and " & W
Ramona WoitasOP
@Reply 4 years ago
Thanks for the info Adam, I just want to make sure that I don't screw things up. So are you saying:
- On CheckRegF - In RequeryForm SUB - Change the 2 lines you noted above
- And You Meant Unbound Invisible Field - Essentially Ends Up Being the AccountID - In the code line above
Right?
Adam Schwanz
@Reply 4 years ago
Yea you just need to change those two lines in the RequeryForm sub in the CheckRegF
As for the unbound invisible field. If you are using the template, I would just do it how I showed with the menu, but you COULD add a line of code to the double cilck event in that list box, that would set the value of an invisible/unbound text box on the CheckRegF. So you'd have your code where you opened the CheckRegF from the listbox and then
(Replace with proper names)
Forms!FormName!UnboundFieldName = ListboxName
Then you would have that ID number stored in your CheckRegF form and wouldn't need to call for the value from the main menu. It's simpler if you do it the other way :P but an option.
Ramona WoitasOP
@Reply 4 years ago
That's awesome. Thank you for the detailed reply. That helps a lot.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
