[Event Procedure] alteration help, PLZ!!!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rigby - 05 Dec 2005 15:31 GMT

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

Reply to this Message

Klatuu - 05 Dec 2005 15:38 GMT

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.

> 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
[quoted text clipped - 5 lines]
>
> Rigby

Reply to this Message

rigby - 05 Dec 2005 15:51 GMT

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

> 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
[quoted text clipped - 9 lines]
> >
> > Rigby

Reply to this Message

Klatuu - 05 Dec 2005 15:57 GMT

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.

> 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
[quoted text clipped - 17 lines]
> > >
> > > Rigby

Reply to this Message

Dirk Goldgar - 06 Dec 2005 06:24 GMT

> 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.
[quoted text clipped - 3 lines]
> 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.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message

David C. Holley - 05 Dec 2005 17:09 GMT

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
[quoted text clipped - 17 lines]
>>>
>>>Rigby

Reply to this Message

David C. Holley - 05 Dec 2005 17:08 GMT

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.

> 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
[quoted text clipped - 5 lines]
>
> Rigby

Reply to this Message