[Event Procedure] alteration help, PLZ!!!

[Guest]

i'm new to this, especially VBA. i have a pre-made database and am making
customized alterations for my company. there is a button (Add New) for a new
record on my main contacts form. i have changed the order of some of the
fields which i was able to rearrange the tab order for. BUT when i click on
the 'Add New' button, it takes me straight to the old 1st tab. i need to make
it tab to the new first tab. how can i go about this?? please help..
thank you

Rigby

 

[Guest]

Open your form in design mode. Right click the square at the upper left edge
of the form. Select Tab Order, then put the controls in the order you want
and save the form.

 

[Guest]

Thank you Klatuu. But that tab order is in the right order. the button is in
the 'form header' and the field i wish it to tab striaght to is in the
'Detail' section of the design view. the field is in the correct tab order,
yet it still tabs to the field below it which was the initial first feild.
sorry, am I making sense?

Rigby

 

[Guest]

Look to see if there is any code that may be explicitly setting the focus to
the other control. I am pretty sure this is the problem. The reason I think
so is because if there are controls in the header, the tab stops at the first
control in the tab order for the header. You can't tab from header to
detail, you have to use the mouse; therefore, I would expect you will find
code in the On Load event that is move the focus, but it could be someplace
else.

 

[David C. Holley]

Check the TAB order. VIEW>TAB ORDER when the form is in design view.

If you are new to Access, I would *HIGHLY* recommend that you pick up
some books on the application. Doing so will save you a great amount of
time when dealing with problems. You will find that you will either be
able to quickly deal with the problem w/out posting and that when you
post you'll be able to succiently(sp?) state the issue and understand
the replies.

 

[David C. Holley]

Where is the OLD 1st field located?

Thank you Klatuu. But that tab order is in the right order. the button is in
the 'form header' and the field i wish it to tab striaght to is in the
'Detail' section of the design view. the field is in the correct tab order,
yet it still tabs to the field below it which was the initial first feild.
sorry, am I making sense?

Rigby

:

 

[Dirk Goldgar]

Look to see if there is any code that may be explicitly setting the
focus to the other control. I am pretty sure this is the problem.
The reason I think so is because if there are controls in the header,
the tab stops at the first control in the tab order for the header.
You can't tab from header to detail, you have to use the mouse;
therefore, I would expect you will find code in the On Load event
that is move the focus, but it could be someplace else.

The Add New button's Click event, and the form's Current event, would be
likely places to look.