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: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
> Of Bob Rosenblum
> Sent: Saturday, June 03, 2006 6:12 PM
> To: [email protected]
> 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: [email protected] [mailto:[EMAIL PROTECTED] On
> Behalf
> > Of Bob
> > Sent: Sunday, May 21, 2006 7:55 PM
> > To: [email protected]
> > 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 [email protected], 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]
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.
