Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / July 2008

Tip: Looking for answers? Try searching our database.

First field default in form with header & details

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Roddy B - 29 Jul 2008 22:40 GMT
Access 2003
When my form opens the cursor defaults to the first field in the tab order
of the Details section.  Upon opening I want the form to default the cursor
to the first field in the tab order of the Form Header section.  Any advise
is welcome.
bhicks11 - 29 Jul 2008 22:59 GMT
Hi Roddy,

In the OnCurrent Event of the form, put:

me.whatevercontrol.setfocus

Bonnie
http://www.dataplus-svc.com

>Access 2003
>When my form opens the cursor defaults to the first field in the tab order
>of the Details section.  Upon opening I want the form to default the cursor
>to the first field in the tab order of the Form Header section.  Any advise
>is welcome.
Roddy B - 30 Jul 2008 15:32 GMT
Hey Bonnie.
In Form properties, Event tab, On Current I inserted the code.  Upon opening
the form still defaults to the first field of the details section.
Any other ideas?
Thanks!
Roddy

> Hi Roddy,
>
[quoted text clipped - 10 lines]
> >to the first field in the tab order of the Form Header section.  Any advise
> >is welcome.
bhicks11 - 30 Jul 2008 15:49 GMT
It worked here for me.  Look at your form events and see if there is anything
running that puts it there.  Also, make sure you placed the above code in the
form OnCurrent event.

Bonnie
http://www.dataplus-svc.com

>Hey Bonnie.
>In Form properties, Event tab, On Current I inserted the code.  Upon opening
[quoted text clipped - 8 lines]
>> >to the first field in the tab order of the Form Header section.  Any advise
>> >is welcome.
Roddy B - 30 Jul 2008 16:13 GMT
Yep, I placed it On Current event.  The only other thing running is...

Private Sub Form_Load()
DoCmd.Maximize
End Sub

...as an On Load event.  Thanks for trying!

> It worked here for me.  Look at your form events and see if there is anything
> running that puts it there.  Also, make sure you placed the above code in the
[quoted text clipped - 15 lines]
> >> >to the first field in the tab order of the Form Header section.  Any advise
> >> >is welcome.
bhicks11 - 30 Jul 2008 19:44 GMT
Make sure the maximize is the first thing but other than that check your
other controls that might be running something.

Bonnie
http://www.dataplus-svc.com

>Yep, I placed it On Current event.  The only other thing running is...
>
[quoted text clipped - 9 lines]
>> >> >to the first field in the tab order of the Form Header section.  Any advise
>> >> >is welcome.
Roddy B - 30 Jul 2008 19:59 GMT
Thanks, I will see what I can find.
Roddy

> Make sure the maximize is the first thing but other than that check your
> other controls that might be running something.
[quoted text clipped - 15 lines]
> >> >> >to the first field in the tab order of the Form Header section.  Any advise
> >> >> >is welcome.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.