Is the default view of the form inside the subform control Single Form or
Continous Form? If so, then records in the Form Header section should
appear in the subform control. You won't see the headers if the form is in
Datasheet view.
John Viescas, author
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
Running Microsoft Access 2000
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
For the inside scoop on Access 2007, see:
http://blogs.msdn.com/access/
-----Original Message-----
From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Bob Rosenblum
Sent: Sunday, June 04, 2006 12:45 AM
To: ms_access@yahoogroups.com
Subject: RE: [ms_access] Re: headings in sub forms
John I think I misunderstood your question. Yes, the detail lines in the
subform are
linked to actual fields on one of the tables.
Here is an overview. It is a Donor Database. There is one table for donors
and
another for donations.
So, Donor is the form and donations the subform.
When I put a heading in the subform, it doesn't show. The data for the
subform
DOES show. Every donation made by a particular donor shows up.
Does that help?
bob
On 3 Jun 2006 at 23:11, John Viescas wrote:
> bob-
>
> Unless you define bound controls in the detail section, you won't see any
> data. And if the record in the outer form has no related records in the
> subform, you might not see the headers either if the Record Source of the
> subform is not updatable. When you open a form on a non-updatable
recordset
> that has no records, the form will appear blank. What is the Record
Source
> of your subform?
>
> John Viescas, author
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> Running Microsoft Access 2000
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
> For the inside scoop on Access 2007, see:
> http://blogs.msdn.com/access/
>
>
> -----Original Message-----
> From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On
Behalf
> Of Bob Rosenblum
> Sent: Saturday, June 03, 2006 6:12 PM
> To: ms_access@yahoogroups.com
> Subject: RE: [ms_access] Re: headings in sub forms
>
> Sorry for waiting so long to reply.
>
> I do not have bound controls defined in the detail section.
>
> What is happening, is I am creating a subform. Then using the heading for
> the
> subform to place a label in. When going to form view, this label is not
> visible.
>
> bob
>
> On 21 May 2006 at 20:08, John Viescas wrote:
>
> > Bob-
> >
> > Do you have bound controls defined in the Detail section of your form
> > design? What exactly do you mean by "disappear on me?"
> >
> > John Viescas, author
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > Running Microsoft Access 2000
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Paris, France)
> > For the inside scoop on Access 2007, see:
> > http://blogs.msdn.com/access/
> >
> >
> > -----Original Message-----
> > From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On
> Behalf
> > Of Bob
> > Sent: Sunday, May 21, 2006 7:55 PM
> > To: ms_access@yahoogroups.com
> > Subject: [ms_access] Re: headings in sub forms
> >
> >
> > I tried doing that, but when I select single or continuous, the
> > heading shows just fine, but the details disappear on me.
> >
> > bob
> >
> > --- In ms_access@yahoogroups.com, Lonnie Johnson <[EMAIL PROTECTED]> wrote:
> > >
> > > You subform's default view must be "single" or "continuous" (cannot
> > be datasheet) and you must put the controls in the subform's "FORM
> > HEADER" section and not the "PAGE HEADER" section.
> > >
> > > Bob <[EMAIL PROTECTED]> wrote: I find that whenever I try to put headings in
> > subforms, they
> > > disappear...Can anyone tell me how to get them to show?
> > >
> > > bob
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > SPONSORED LINKS
> > > Microsoft access database Database development software
> > Database management software Database software Inventory
> > database software Membership database software
> > >
> > > ---------------------------------
> > > YAHOO! GROUPS LINKS
> > >
> > >
> > > Visit your group "ms_access" on the web.
> > >
> > > To unsubscribe from this group, send an email to:
> > > [EMAIL PROTECTED]
> > >
> > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> > Service.
> > >
> > >
> > > ---------------------------------
> > >
> > >
> > >
> > >
> > >
> > >
> > > May God bless you beyond your imagination!
> > > Lonnie Johnson
> > > ProDev, Professional Development of MS Access Databases
> > > Visit me at ==> http://www.prodev.us
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > ---------------------------------
> > > Feel free to call! Free PC-to-PC calls. Low rates on PC-to-Phone.
> > Get Yahoo! Messenger with Voice
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
> > --
> > No virus found in this incoming message.
> > Checked by AVG Free Edition.
> > Version: 7.1.392 / Virus Database: 268.6.1/344 - Release Date: 5/19/2006
> >
>
> ~
> Bob Rosenblum
> PO Box 3027
> Albany, NY 12203
> Phone: 518-459-6212
> Email: [EMAIL PROTECTED]
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.394 / Virus Database: 268.8.1/355 - Release Date: 6/2/2006
>
~
Bob Rosenblum
PO Box 3027
Albany, NY 12203
Phone: 518-459-6212
Email: [EMAIL PROTECTED]
Yahoo! Groups Links
SPONSORED LINKS
| Microsoft access database | Database development software | Database management software |
| Database software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
