Recent content by kaneymac

Yeah I SAW that and this thing was makin me an unbeliever. If I hit "add to reputation" do you at least get some kudos or something for helping me?

YES IT WORKS BEAUTIFULLY!! If I knew who you are I'd pay you for that! I REALLY appreciate your time and troubleshooting. Thanks very much. I get to keep my job!! :D

lemme make sure I explained the "nesting" correctly, or whatever it's called. Account Details (main form) ---> TabCtl171 (tab control) ---> Billed (tab page 1) ---> Transactions Subform (subform) ---> TransactionID (control) I'm wondering if the fact that I have the same subform on 3...

still just opens the form to the first record, not the correct TransactionID :(

TransactionID is an AutoNumber in the Transactions Table.

I just tried... and it works great if I just view Transactions Subform independently (not from the main form). It goes straight to the same TransactionID on Transaction Details. but if I put Transactions Subform on the page 1 of the tab control on Account Details, it asks for the value for...

doh!! It does open the form, but only takes me to the first of ## records.

That pops up a box asking for the value for Me!TransactionID.

actually this is my current code: Private Sub TransactionID_Click() Dim stDocName As String Dim stLinkCriteria As String stDocName = "Transaction Details" stLinkCriteria = "Forms!Access_Details.Transactions_Subform.Form.TransactionID = TransactionID" DoCmd.OpenForm stDocName, , ...

I've seen similar issues posted, but when I copy the answer code, it doesn't seem to work, so I'm hoping for clarification. Here's my hierarchy: Main Form: "Account Details" Tab Control: "TabCtl171" Page: "Billed" Sub Form: "Transactions Subform" So Transactions Subform displays a continuous...