Tabbed form

[Rpettis31]

I have a tabbed area in a form yet I have done something to where when I add
a new record the form it opens on the second tab instead of the first how do
I fix that?

 

[Al Campagna]

Rpettis31,
Have you checked the "Page Order" of the Tab Control?
Select the Tab Control (the entire control, not an individual page), and
right click.
Use the Page Order to set up the "top" tab page.

Of course, it is possible, through code, to make a "lower" tab page
display first, so make sure you check that out.
Example...using the OnCurrent event of the form, and responding to some
condition, Page 3 could be forced open when the form does.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Rpettis31]

The page order is correct. Yet when I select the button to add a record the
second tab is showing first, the same with the view record...

 

[Rpettis31]

It seems to work however when I go to view all the records I receive this
error.

The expression on current you entered as the event property setting produced
the following error: Ambiguous name detected:Form_Current

 

[Al Campagna]

Rpettis31,
That sounds like you have two instances of Form_Current code in your
form module.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Rpettis31]

Thanks for your help had code i did not need in the module when I was using a
subform on tab 2...
This is probably why it goes to this tab when the form is opened any ideas