Change Tab Order

[Guest]

I know this is probably a very simple fix but.....I would like to change the
Tab order in a record to move from the form header to the details and then to
the form footer. I have tried the tab order in design view but I can't seem
to get it....any suggestions?

 

[Jeff Boyce]

Sara

Headers, footers and detail are separate sections, and each has its own tab
order.

You may have to add code to the OnExit event of the "last" control in each
section ... your code would SetFocus on the next section's "first" control.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Hi Jeff,
Thanks but I'm not to familiar with writing code just sort of teaching
myself. Can you be a bit more specific or point me in the right direction to
get the information I need?
Thanks again....I'm slowly starting to get the picture.

Regards, Sara

 

[Guest]

OK I got it so forget my last post but....I do have another question you
might be able to help with.....How do I get the form to open in the form
header? Have tried the OnOpen function but I can't seem to get the right
code......Your thoughts?

Thanks Again!
Sara

 

[Jeff Boyce]

Sara

Are you using the

<some control>.SetFocus

command?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Hi Jeff,
I went to the properties of the form to the On Open and built this event

DoCmd.GoToControl."PositionTypeID".SetFocus

But that didn't work......where am I going wrong?

Sara

 

[Jeff Boyce]

Sara

Simply:
PositionTypeID.SetFocus

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Hi Jeff,

Not sure why but it's giving me a run-time error '2950' reserved error. Any
ideas?

Sara

 

[Jeff Boyce]

Sara

No idea, off the top of my head. Not being there/seeing that does make
diagnosis a bit tricky, though.

Sometimes Access forms become "subtly corrupted", and no amount of tinkering
seems to fix them. When this seems to be happening to me, I (re-)create the
form from scratch and try again. Seems to help...

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Hi Jeff,

I got it! Realized that I should just add it to my On_Load command.
Thank-you, you have been a tremendous help.

Thanks again!

Sara