My account: Login | Sign Up
Loading... 

Problem with subform in Access 2007 - works fine in Access 2003 in microsoft.public.access.forms | Thread profile

Thread profile page for "Problem with subform in Access 2007 - works fine in Access 2003 in microsoft.public.access.forms" on http://www.microsoft.com/communities/newsgroups.... This report page is a snippet summary view from a single thread "Problem with subform in Access 2007 - works fine in Access 2003 in microsoft.public.access.forms", located on the Message Board at http://www.microsoft.com/communities/newsgroups.... This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity, which are reported in a table below. Additional thread profile information is also shown in the following ways:

1) Top Contributing Authors
2) Related Threads on "eBay Auctions"
3) Related Threads on Other Sites

Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a thread's popularity and/or exact posting volumes at any given reporting period.
Title: Problem with subform in Access 2007 - works fine in Access 2003 in microsoft.public.access.forms
Site: Discussions in microsoft.public.access.forms  Discussions in microsoft.public.access.forms - site profile
Forum: microsoft.public.access.forms  microsoft.public.access.forms - forum profile
Total authors: 2 authors
Total thread posts: 6 posts
Thread activity: no new posts during last week
Domain info for: microsoft.com

Thread posts in Problem with subform in Access 2007 - works fine in Access 2003 in microsoft.public.access.forms:

1. 
Started 11 months ago (2008-01-03 14:27:00)  by CinBar
I have a subform linked to the main form with a bidder number field. In the subform, I added an LS header, with the 'Live or Silent' field in that header so that the form would list all Live records first under a Live heading, and then the Silent records under a Silent heading. The subform works perfectly by itself, but when I put in in...
Size: 1,479 bytes
Customize:  Customize "Problem with subform in Access 2007 - works fine in Access 2003 in microsoft.public.access.forms :: microsoft.public.access.forms :: Discussions in microsoft.public.access.forms"
2. 
Started 11 months ago (2008-01-03 15:04:00)  by NetworkTrade
If all works well in Access2003 and it is not working in Access2007; then I would recommend in 07 that you look at the queries that are the record sources for the Form/Report and its Sub Form/Report. 1. Be sure that the key field is in the queries 2. Be sure that the key field is in the actual form/report/subform/report - even...
Size: 2,590 bytes
Customize:  Customize "<b>Reply 1</b>: Problem with subform in Access 2007 - works fine in Access 2003 in microsoft.public.access.forms :: microsoft.public.access.forms :: Discussions in microsoft.public.access.forms"
3. 
Started 11 months ago (2008-01-04 07:05:00)  by CinBar
Thanks for your reply, but unfortunately, that didn't help. Here's what I did: The subform is based on a table, not a query. The key field, which is the item# field, was in the subform. The main form is basically just a heading, showing the winning bidder number derived from a query, a bit of text, and three subforms. The ...
Size: 3,849 bytes
Customize:  Customize "<b>Reply 2</b>: Problem with subform in Access 2007 - works fine in Access 2003 in microsoft.public.access.forms :: microsoft.public.access.forms :: Discussions in microsoft.public.access.forms"
4. 
Started 11 months ago (2008-01-04 07:12:00)  by NetworkTrade
I do also remember being perplexed by an 07 behavior where the form/report was sourced directly on the table. Out of desperation I made a query that had all the fields and sourced the form/report on the query rather than the table itself.....and this fixed it.... I see that you state that the subform is sourced right on a table ...
Size: 4,882 bytes
Customize:  Customize "<b>Reply 3</b>: Problem with subform in Access 2007 - works fine in Access 2003 in microsoft.public.access.forms :: microsoft.public.access.forms :: Discussions in microsoft.public.access.forms"
5. 
Started 11 months ago (2008-01-04 07:38:00)  by CinBar
I created a query, pointed the subreport to that query and it now works fine. Thanks so much for the suggestion. Is it just me, or does it seem like this is an issue with Access 2007 rather than "the correct method" of doing things? "NetworkTrade" wrote: > I do also remember being perplexed by an 07 behavior where the form/...
Size: 5,585 bytes
Customize:  Customize "<b>Reply 4</b>: Problem with subform in Access 2007 - works fine in Access 2003 in microsoft.public.access.forms :: microsoft.public.access.forms :: Discussions in microsoft.public.access.forms"
6. 
Started 11 months ago (2008-01-04 07:50:00)  by NetworkTrade
glad it worked. yes the fact that a form/report must always source to a query and never directly onto a table surely seems like a thing that should be better explained....not sure if it is a bug or if there is some rationale toward it that I don't yet understand...but it is a major change. also you will find in 07 that ...
Size: 6,690 bytes
Customize:  Customize "<b>Reply 5</b>: Problem with subform in Access 2007 - works fine in Access 2003 in microsoft.public.access.forms :: microsoft.public.access.forms :: Discussions in microsoft.public.access.forms"
 

Top contributing authors for Problem with subform in Access 2007 - works fine in Access 2003 in microsoft.public.access.forms

Name
Posts
CinBar
3
user's latest post:
Problem with subform in Access...
Published (2008-01-04 07:38:00)
&nbsp; I created a query, pointed the subreport to that query and it now works fine. Thanks so much for the suggestion. Is it just me, or does it seem like this is an issue with Access 2007 rather than &quot;the correct method&quot; of doing things? &quot;NetworkTrade&quot; wrote: &gt; I do also remember being perplexed by an 07 behavior where the form/report &gt; was sourced directly on the table. Out of...
NetworkTrade
3
user's latest post:
Problem with subform in Access...
Published (2008-01-04 07:50:00)
&nbsp; glad it worked. yes the fact that a form/report must always source to a query and never directly onto a table surely seems like a thing that should be better explained....not sure if it is a bug or if there is some rationale toward it that I don't yet understand...but it is a major change. also you will find in 07 that putting a Close Form button on a form will often generate an error because it now has code attempting to...

Duplicating MainForm, SubForm and Sub-SubForm in...  Discussions in microsoft.public.access.forms - site profile microsoft.public.access.forms - forum profile Duplicating MainForm, SubForm and Sub-SubForm in microsoft.public.access.forms
Duplicating MainForm, SubForm and Sub-SubForm in microsoft.public.access.forms
Linking subform to subform? in microsoft.public.access.forms  Discussions in microsoft.public.access.forms - site profile microsoft.public.access.forms - forum profile Linking subform to subform? in microsoft.public.access.forms
Linking subform to subform? in microsoft.public.access.forms
Update information on a subform from another subform in...  Discussions in microsoft.public.access.forms - site profile microsoft.public.access.forms - forum profile Update information on a subform from another subform in microsoft.public.access.forms
Update information on a subform from another subform in microsoft.public.access.forms
Subform in subform in microsoft.public.access.forms  Discussions in microsoft.public.access.forms - site profile microsoft.public.access.forms - forum profile Subform in subform in microsoft.public.access.forms
Subform in subform in microsoft.public.access.forms
Subform to select record for subform in...  Discussions in microsoft.public.access.forms - site profile microsoft.public.access.forms - forum profile Subform to select record for subform in microsoft.public.access.forms
Subform to select record for subform in microsoft.public.access.forms
Access 2007 closing prompts to save subform in...  Discussions in microsoft.public.access.forms - site profile microsoft.public.access.forms - forum profile Access 2007 closing prompts to save subform in microsoft.public.access.forms
Access 2007 closing prompts to save subform in microsoft.public.access.forms
HOW DO I ACCESS THE DETAIL OBJECT IN A SUBFORM in...  Discussions in microsoft.public.access.forms - site profile microsoft.public.access.forms - forum profile HOW DO I ACCESS THE DETAIL OBJECT IN A SUBFORM in microsoft.public.access.forms
HOW DO I ACCESS THE DETAIL OBJECT IN A SUBFORM in microsoft.public.access.forms
Lost on using ComboBox with subform (Access 2003) in...  Discussions in microsoft.public.access.forms - site profile microsoft.public.access.forms - forum profile Lost on using ComboBox with subform (Access 2003) in microsoft.public.access.forms
Lost on using ComboBox with subform (Access 2003) in microsoft.public.access.forms
Linking a Combo box to variable SQL query in subform in...  Discussions in microsoft.public.access.forms - site profile microsoft.public.access.forms - forum profile Linking a Combo box to variable SQL query in subform in microsoft.public.access.forms
Linking a Combo box to variable SQL query in subform in microsoft.public.access.forms
Can't keep focus on second row of subform in...  Discussions in microsoft.public.access.forms - site profile microsoft.public.access.forms - forum profile Can't keep focus on second row of subform in microsoft.public.access.forms
Can't keep focus on second row of subform in microsoft.public.access.forms
Linking one subform to another subform in...  Discussions in microsoft.public.access.gettingstarted - site profile microsoft.public.access.gettingstarted - forum profile Linking one subform to another subform in microsoft.public.access.gettingstarted
Linking one subform to another subform in microsoft.public.access.gettingstarted
Form + (subForm) in microsoft.public.nl.office.access  Discussions in microsoft.public.nl.office.access - site profile microsoft.public.nl.office.access - forum profile Form + (subForm) in microsoft.public.nl.office.access
Form + (subForm) in microsoft.public.nl.office.access
Verversen gegevens in subform in...  Discussions in microsoft.public.nl.office.access - site profile microsoft.public.nl.office.access - forum profile Verversen gegevens in subform in microsoft.public.nl.office.access
Verversen gegevens in subform in microsoft.public.nl.office.access
Keuzelijsten aan elkaar koppelen voor elke regel in...  Discussions in microsoft.public.nl.office.access - site profile microsoft.public.nl.office.access - forum profile Keuzelijsten aan elkaar koppelen voor elke regel in subform in microsoft.public.nl.office.access
Keuzelijsten aan elkaar koppelen voor elke regel in subform in microsoft.public.nl.office.access
Einen Datensatz weiter, aus einem Subform im Subform und...  Discussions in microsoft.public.de.access - site profile microsoft.public.de.access - forum profile Einen Datensatz weiter, aus einem Subform im Subform und dessen Subform in microsoft.public.de.access
Einen Datensatz weiter, aus einem Subform im Subform und dessen Subform in microsoft.public.de.access
Número Sequencial em subform in microsoft.public.pt.access  Discussions in microsoft.public.pt.access - site profile microsoft.public.pt.access - forum profile Número Sequencial em subform in microsoft.public.pt.access
Número Sequencial em subform in microsoft.public.pt.access
Passar dados de uma listbox para um subform in...  Discussions in microsoft.public.pt.access - site profile microsoft.public.pt.access - forum profile Passar dados de uma listbox para um subform in microsoft.public.pt.access
Passar dados de uma listbox para um subform in microsoft.public.pt.access
Export Filter in a subform in...  Discussions in microsoft.public.access.externaldata - site profile microsoft.public.access.externaldata - forum profile Export Filter in a subform in microsoft.public.access.externaldata
Export Filter in a subform in microsoft.public.access.externaldata
Deleting records in a subform of a subform in...  Discussions in microsoft.public.access - site profile microsoft.public.access - forum profile Deleting records in a subform of a subform in microsoft.public.access
Deleting records in a subform of a subform in microsoft.public.access
How do I make a report print a certain subform in...  Discussions in microsoft.public.access.reports - site profile microsoft.public.access.reports - forum profile How do I make a report print a certain subform in microsoft.public.access.reports
How do I make a report print a certain subform in microsoft.public.access.reports