on click event on tab sheet

[SITCFanTN]

I think this must be so simple because I can't find any other posts on this
exact topic so I appreciate any help you can give me. I posted this question
once in the Forms Coding section and didn't get any helpful response, I'm
hoping I have better luck here. Please help if you can.

I have a form with tab controls on it. What I want to accomplish is when a
tab is clicked, have the tab name fill in the "TASKID" field in the table
"tblQAData" for that record. One of the tabs is titled "Balancing". The
field "TASKID" is a dropdown, will that cause a problem with coding this? Do
I need to add the "TaskID" filed to the tab sheet to get it to prefill when
the tab is clicked or record saved? Any help you can provide is appreciated.
Thank You

 

[Marshall Barton]

I think this must be so simple because I can't find any other posts on this
exact topic so I appreciate any help you can give me. I posted this question
once in the Forms Coding section and didn't get any helpful response, I'm
hoping I have better luck here. Please help if you can.

I have a form with tab controls on it. What I want to accomplish is when a
tab is clicked, have the tab name fill in the "TASKID" field in the table
"tblQAData" for that record. One of the tabs is titled "Balancing". The
field "TASKID" is a dropdown, will that cause a problem with coding this? Do
I need to add the "TaskID" filed to the tab sheet to get it to prefill when
the tab is clicked or record saved? Any help you can provide is appreciated.
Thank You

I think all you need os one line of code in the tab
control's Change event procedure:
TaskID = tabcontrol.Pages(tabcontrol.Value).Name