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 2008

Tip: Looking for answers? Try searching our database.

Problem with subform requery

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
schmoopiesdad - 07 Mar 2008 16:57 GMT
Hi and Thank you -

I'm crreating an inventory control database for an experimental animal colony.
I have a form with with seven subforms - each of which has a particular piece
of info about the animal - frmStudyUse which gives a list of the studies of
which the animal has been a part in datasheet format. For each of these forms
I have a button which opens a form to add a new entry to the available list -
ex. frmStudyUseAddName - which the user can access while updating the
particular animal's record instead of going back through several layers of
switchboards. Fairly strightforward.

Here's the problem - I can get the subforms to update once, but if you need
to open the frmStudyUseAddName a second time, the requery will not work.

I've tried both these codes:

Forms.frmAnimalInformation.frmStudyUse.form.requery

and

Me.frmAnimalInformation.frmStudyUse.form.requery

Can you tell the problem?

Ike Horton
schmoopiesdad - 07 Mar 2008 16:59 GMT
Sorry, second line of code should read:

Me.frmStudyUse.form.requery

>Hi and Thank you -
>
[quoted text clipped - 21 lines]
>
>Ike Horton
 
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



©2009 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.