Text Box Updating Wrong Record

[wyvern621]

Happy Monday All...

I have a database that keeps up with how many customers are being "worked"--we like to call it a Scorecard.

There is a main form ("Scorecard") and a subform ("Transaction Subform"). The main from has a drop down box with a list of customers. The subform has 4 fields that update a table called "Transactions". How this works is an analyst selects a customer and enters the activity on the subform and between the two they update the "Transactions" table with all 5 pieces of information. Works fine--sort of...

The subform "Transaction Subform" is contained within a Tab Control called TabClt2. The first page is the "Activities" page and that's where the subform lives. The second page is called the "Comments" page and should correspond with the "Comments" field on the "Transaction" table and it does--I can't seem to figure out how to click on the "Comments" tab and the "Comments" field correspond to the current record. Right now, the comments field populates, but always for the first record of the "Transaction" table.

How can I make the "Comments" text box on the "Comments" tab update right along with the current record of the "Transaction Subform"?

So far, On Click (for the Comments tab)I've used:

DoCmd.GoToRecord acDataForm, "Transaction Subform", acGoTo, CurrentRecord

This isn't working and I know it's because I haven't associated the "Comments" field to the current record, but I don't know how.

Does anyone have any ideas?

Thanks in advance for your assistance.

ChiTownDiva

 

[BrianLe]

I'm not quite sure I understand your question, but I think you have to set up the subform property link master/child.

 

[wyvern621]

Thanks BrianLe....

I have the subform property link set up correctly. My subform is collecting information to the transaction table. The problem is with the comment text box on the second tab--it keeps taking whatever comments I type in and recording them in the comment field of the first record of Transaction table instead of the current record of Transaction table.

ChiTownDivaus