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 Programming / June 2007

Tip: Looking for answers? Try searching our database.

subform events

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mary Fran - 22 Jun 2007 02:28 GMT
Is there a way to have a subform collapse programatically in the afterupdate
event of one of its fields?  Also, how do I set the focus to a subform field
when the form is expanded?  
Thanks.
tina - 22 Jun 2007 06:30 GMT
what do you mean by "collapse" and "expand"?

> Is there a way to have a subform collapse programatically in the afterupdate
> event of one of its fields?  Also, how do I set the focus to a subform field
> when the form is expanded?
> Thanks.
Mary Fran - 22 Jun 2007 13:13 GMT
In datasheet view, by pressing the + or - sign.

> what do you mean by "collapse" and "expand"?
>
[quoted text clipped - 4 lines]
> > when the form is expanded?
> > Thanks.
tina - 23 Jun 2007 17:29 GMT
sounds like your subform's SourceObject property is set to a table object,
not to another form object, is that correct? and the table has its'
Subdatasheet property set to [Auto] or to the name of another table, is that
correct?

if so, i don't think there's any way to do what you're asking. fields in
table have properties, of course, but not the Event properties that you find
in form objects and form controls. that's one reason that it's recommended
that users never have direct access to tables, all data interaction should
be performed through forms - where the developer can control those
interactions.

hth

> In datasheet view, by pressing the + or - sign.
>
[quoted text clipped - 6 lines]
> > > when the form is expanded?
> > > Thanks.
 
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.