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 / March 2007

Tip: Looking for answers? Try searching our database.

Problems with Tab

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Linda RQ - 11 Mar 2007 23:28 GMT
Hi Everyone,

Access 2003.  I have a Main form with 2 subforms in the detail sections of
my Main form.  I have 7 controls to enter data in, patient info.  All of
these work fine and in order the first control is tab stop 0.  I have
subform 1 Pt Location as tab stop 7, the 5 controls in there are in order
starting with 0 and once in that form those work fine.  My problem is, when
I add a new record to my main form and fill in some of the 7 controls then
hit the tab key or click in the first control on my location subform  I get
switched to an existing record with the focus on tab stop 0 of the Pt
Location subform and I have to go back and find the record I was in the
process of adding then I can click in the first field of my Pt location form
and enter it.  If I tab through a new record without entering any data in
any controls, the tabs work perfectly.

Thanks,
Linda
Devlin - 11 Mar 2007 23:55 GMT
Linda,

I assume that you have some kind of requery method set up in the parent form
so that when you move to the next/previous record, your subform will display
correlated data.  My question is this... On what event do you do the requery?
If you aren't doing it OnCurrent, then this could be your problem.

That's what it sounds like.

> Hi Everyone,
>
[quoted text clipped - 13 lines]
> Thanks,
> Linda
Linda RQ - 12 Mar 2007 00:30 GMT
Hi Devlin,

On Load I have a maximize macro, and on Got Focus I also have a mizimize
macro because when I go to a report then come back, the form was not
maximized.  I have had a lot of help with code so I don't know for sure what
it's doing but this is what I have in the properties of my parent form.

Private Sub Form_AfterUpdate()

   Me.Requery

End Sub

> Linda,
>
[quoted text clipped - 30 lines]
>> Thanks,
>> Linda
Joe - 12 Mar 2007 10:00 GMT
Linda,

What is happening in the After Update Event of the main form is
that when you leave the main form it gets requeried as you wrote
the code for it to do.  This sets the pointer back to the firs
record.

You should use Me.Refresh instead of Me.Requery.

HTH,

Joe

> Hi Everyone,
>
[quoted text clipped - 15 lines]
> Thanks,
> Linda
 
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.