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

Tip: Looking for answers? Try searching our database.

combo box in subform

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Caravatis - 27 Sep 2007 14:55 GMT
Hello, I am new to access and I keep running into a problem.  I have created
a form that is based on a query to dispay records in a few fields based on an
entry in a combo box in the form.  I have it running smoothly, however when I
assigned the form as a subform in a parent form the query will not run.  I
have tried just about everything including designing the subform after the
query itself.  What can I do?  I am trying to achieve a similar outcome to
the "Order Details" subform in the Northwind sample database.
Thanks!
scubadiver - 27 Sep 2007 15:36 GMT
If the query has a criteria reference in it, it will be wrong now that you
have added an extra layer:

[forms]![form name]![subform name].form![combo name]

Signature

"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video

> Hello, I am new to access and I keep running into a problem.  I have created
> a form that is based on a query to dispay records in a few fields based on an
[quoted text clipped - 4 lines]
> the "Order Details" subform in the Northwind sample database.
> 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.