<div>
Your question has appeared in the Microsoft Word area, but tabs and the onFormLoad event are unfamiliar in Word VBA forms. Is it in some other environment?<br />
<br />
That being said, it sounds as if you should call your code from the Click or Change event of the combo.<br />
<br />
Sub Combo1_Change()<br />
if Combo1.text = &quot;A&quot; then<br />
'...
</div>


Your question has appeared in the Microsoft Word area, but tabs and the onFormLoad event are unfamiliar in Word VBA forms. Is it in some other environment?

That being said, it sounds as if you should call your code from the Click or Change event of the combo.

Sub Combo1_Change()
if Combo1.text = "A" then
'...

<div>
***Can a Mod move this to Access Please?***<br />
That's what I'm doing right now but it doesn't help because I need it to check this condition as soon as each new record loads into the form when moving through them.
</div>


***Can a Mod move this to Access Please?***
That's what I'm doing right now but it doesn't help because I need it to check this condition as soon as each new record loads into the form when moving through them.

<div>
<div class="content wysiwyg-content">
I have a form using Tabs. &nbsp;I know how to allow a specific tab to only show when the value of a combo is correct, but I can't get it to auto-update when moving through current records. &nbsp;Everytime a already-entered record is on the screen I need it to check pmStyle. &nbsp;<br />
If it's &quot;A&quot; then <br />
Me.TabA.Visible = True<br />
Me.TabB.Visible = False<br />
If it's &quot;B&quot; then<br />
Me.TabA.Visible = False<br />
Me.TabB.Visible = True<br />
<br />
Like I said, I can do this with a combo and I can do it onFormLoad but only for the first record that shows then it stays the same. &nbsp;How I can take that same code and run it every time you flips to a different record?
</div>
</div>


I have a form using Tabs.  I know how to allow a specific tab to only show when the value of a combo is correct, but I can't get it to auto-update when moving through current records.  Everytime a already-entered record is on the screen I need it to check pmStyle.  
If it's "A" then 
Me.TabA.Visible = True
Me.TabB.Visible = False
If it's "B" then
Me.TabA.Visible = False
Me.TabB.Visible = True

Like I said, I can do this with a combo and I can do it onFormLoad but only for the first record that shows then it stays the same.  How I can take that same code and run it every time you flips to a different record?

Show/Hide Specific Tabs on Record Change

Microsoft Word is a commercial document editing program that is part of the Microsoft Office suite. It features numerous text-editing tools for creating richly formatted documents, along with tools for the use of macros in Word documents. Word's native file formats are denoted either by a .doc or .docx file extension. Plugins permitting the Windows versions of Word to read and write formats it does not natively support, such as the OpenDocument format (ODF) are available. Word can import and display images in common bitmap formats such as JPG and GIF. It can also be used to create and display simple line-art.