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

Tip: Looking for answers? Try searching our database.

Subform wierdness

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rolls - 13 Mar 2007 03:49 GMT
I'm having a strange problem entering a field into a subform.  As soon as I
type the first letter, the form realphabetizes itself.  I then have to move
to the record I entered where the cursor now will replace that letter with
whatever I type next unless I press F2.  Then it will let me type the
remainder of the field.  Recordsource for the subform is a query sorted
ascending.  Why can't I enter a new record before it reacts (badly) when I
try to enter text?  There is no code behind events anywhere.  I don't know
what causes this.  What I expect it to do is wait until all additional
records are entered, then the next time the parent returns to the same ID
everything in the subform is alphabetized.
Damian S - 13 Mar 2007 04:15 GMT
Hi Rolls,

What you are describing sounds like a Requery is being triggered... are you
sure there are no events behind your form?

Damian.

> I'm having a strange problem entering a field into a subform.  As soon as I
> type the first letter, the form realphabetizes itself.  I then have to move
[quoted text clipped - 6 lines]
> records are entered, then the next time the parent returns to the same ID
> everything in the subform is alphabetized.
Rolls - 14 Mar 2007 12:58 GMT
There aren't any.  That is what puzzles me.  Must be more subtle.
 
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.