I have an Invoice form and a InvoiceDetail continuous form. It's easy
to present the header/main data and the detail data as a form/subform.

Let's say we have 12 monthly invoices for year 2010. Is there a method
for presenting all 12 invoices as a form/subform (a form/subform for
each month) in a scrollable list (like a continuous form)?

On Mar 30, 1:04*am, Salad <sa... (AT) oilandvinegar (DOT) com> wrote:
You can make the Invoice form continuous. When you select an
individual invoice its items will still show in the subform.

Salad <salad (AT) oilandvinegar (DOT) com> wrote in
news:Xd2dnfsmI90H7g_QnZ2dnUVZ_tGdnZ2d (AT) earthlink (DOT) com:

The question sounds trivial, so I must be missing something
significant. Here's an example of how I've done it:

http://dfenton.com/DFA/examples/Subdatasheets.png

It uses subdatasheets, and works quite well, seems to me.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

David-W-Fenton wrote:
Thanks much, David, for your reply and the link to a sample. I will
test on Friday.

The backend data is coming from ODBC sources so I hope that doesn't
cause a problem.

I noticed that the data for the main form must be a datasheet. Same for
the subdatasheet. I was hoping the main form didn't have to be
datasheet but this works as I best as I had hoped.

One question I have on the picture sample. I assume you dropped the
form/subdatasheet into a "container" form that had a blue green
backgound. But the space between the main/subdatasheet had a blueish
green tint as well. How the heck did you do that? Is it a setting in
the container form or is it a setting in the form/subdatasheet form?

Salad <salad (AT) oilandvinegar (DOT) com> wrote in
news:u-ydnftSncWYTw7QnZ2dnUVZ_r2dnZ2d (AT) earthlink (DOT) com:

Nope. There are properties of the datasheet object that allow you to
set the color of the background. Remember, a datasheet is just a
FORM (check it out in the object browser in the VBE), so it has most
of the same properties as any form (and some that only apply to
datasheets).

In this case, it's actually a datasheet-specific property,
Me.DatasheetBackColor, that you set.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

David-W-Fenton wrote:


Regarding the colors, I was able to right click on it and set the font
properties to bold and forecolor for the main form. I could set the
backcolor as well but I think I prefer the white background in this
instance.

On Tue, 29 Mar 2011 19:04:42 -0500, Salad <salad (AT) oilandvinegar (DOT) com>
wrote:

Create another form/subform. Put the customer record on the main form
and the invoices on the subform. Then create a "drill down" button on
the subform to open your Invoice/Detail subform mentioned in your
first paragraph.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/