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 / May 2008

Tip: Looking for answers? Try searching our database.

Why is Subform empty when query returns no data

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
RussCRM - 29 May 2008 18:24 GMT
Why are my subforms empty when query returns no data?   Is there a way
for my text boxes to show up and display 0 (zero) values if the query
returns no records?
david@epsomdotcomdotau - 29 May 2008 23:24 GMT
No, the detail section is not created if there are no records.
Subforms only show the detail section, so if there are no
records, there is no subform.  Anything you want to see
when there are no records, you will have to put on the main form.

(david)

> Why are my subforms empty when query returns no data?   Is there a way
> for my text boxes to show up and display 0 (zero) values if the query
> returns no records?
 
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.