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 / April 2005

Tip: Looking for answers? Try searching our database.

Filtering unbound subforms

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Suzie Raboin - 07 Apr 2005 23:55 GMT
I have a database that tracks school districts and all of the construction
projects that they are planning.

The main form of my database is basically a "shell" form with an unbound
subform.  When a user clicks on a menu option it opens the desired form in
the unbound subform.

This unbound subform will not allow me to open a certain form and then apply
a filter based on information that the user has already entered.  When I use
this particular form by itself (not through the subform) everything works
perfectly.

My code to open the form is:

Forms![Switchboard]![Subform].SourceObject = "Projects Per Contract"

Then I want to apply my filter but it keeps telling me that the object does
not support this property or method.  Is that because it's an unbound subform?

Any suggestions would be great!

Thanks!
Allen Browne - 08 Apr 2005 03:47 GMT
Try:
   Forms.[Switchboard].[Subform].Form.Filter = ...

If the ".Form" bit is new, see:
   http://allenbrowne.com/casu-04.html

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have a database that tracks school districts and all of the construction
> projects that they are planning.
[quoted text clipped - 22 lines]
>
> Thanks!
Suzie Raboin - 08 Apr 2005 15:45 GMT
Thanks Allen!  You're a life-saver!  I knew it was something easy, I just
couldn't find it anywhere.

> Try:
>     Forms.[Switchboard].[Subform].Form.Filter = ...
[quoted text clipped - 28 lines]
> >
> > 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.