<div>
I can use that to make it work! Fantastic Thankyou
</div>


I can use that to make it work! Fantastic Thankyou

<div>
<div class="content wysiwyg-content">
Hi all, trust you are keeping well!<br />
<br />
Using MS Access 2010. I have a table that has particular values associated to a particular tab name.<br />
<br />
1 / MainTab<br />
2 / BookingInTab<br />
3 / QuotationTab<br />
<br />
I would like to open a form that contains the tab control and then set the focus to the relevant Tab based on a value that is looked up.<br />
<br />
ie.<br />
<br />
The lookup returns a &quot;1&quot; and then i would open the form:<br />
Docmd.Openform &quot;FormWithTabControl&quot;<br />
<br />
and then<br />
<br />
Forms!FormWithTabControl! ( insert looked up tab name here) . SetFocus<br />
<br />
How do get the tab name in the above line?<br />
<br />
Thanks<br />
Sean
</div>
</div>


Hi all, trust you are keeping well!

Using MS Access 2010. I have a table that has particular values associated to a particular tab name.

1 / MainTab
2 / BookingInTab
3 / QuotationTab

I would like to open a form that contains the tab control and then set the focus to the relevant Tab based on a value that is looked up.

ie.

The lookup returns a "1" and then i would open the form:
Docmd.Openform "FormWithTabControl"

and then

Forms!FormWithTabControl! ( insert looked up tab name here) . SetFocus

How do get the tab name in the above line?

Thanks
Sean

Opening a form based on looked up form name.

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.