Printing selected rows from subform

[gor...@hotmail.com]

I have a form with 2 subforms – one displaying invoice headers, the
other showing the relevant invoice item lines for the selected
invoice header. In the form header, I have a combo box with a list of
customers. When I select a customer, subform1 shows the invoices for
that customer and subform2, the invoice lines.

I am looking for a way to be able to highlight selected invoice
headers, then print from a button on the form, but I am struggling to
think of the right approach.

I thought of putting a new field in the invoice headers table (Print,
format Yes/No), then using that on the form to tick the selected
invoices and use as the basis of code for the print. On completion of
the print, the Print flag would be reset.
But this won’t work, as the data source of the Invoice Headers subform
includes fields from other tables and tells me it is not updateable.

Can anyone suggest a way of achieving this?

Gordon

[Marshall Barton]

gor...@hotmail.com wrote:

You might be able to use Albert's Multi Select stuff at:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

--
Marsh

[gor...@hotmail.com]

On Nov 20, 2:03 pm, Marshall Barton <marshbar...@wowway.com> wrote:

> Marsh- Hide quoted text -
>
> - Show quoted text -

Thanks Marsh, my subform is a datasheet but I'll check out the the
code you suggested which is designed for a continuos form.

Gordon

[Marshall Barton]

gor...@hotmail.com wrote:

>On Nov 20, 2:03�pm, Marshall Barton wrote:
>> gors...@hotmail.com wrote:
>> >I have a form with 2 subforms � one displaying invoice headers, the
>> >other �showing the relevant invoice item lines for the selected
>> >invoice header. In the form header, I have a combo box with a list of
>> >customers. �When I select a customer, �subform1 shows the invoices for
>> >that customer and subform2, the invoice lines.
>>
>> >I am looking for a way to be able to highlight selected invoice
>> >headers, then print from a button on the form, but I am struggling to
>> >think of the right approach.
>>
>> >I thought of putting a new field in the invoice headers table (Print,
>> >format Yes/No), then using that on the form to tick the selected
>> >invoices and use as the basis of code for the print. On completion of
>> >the print, the Print flag would be reset.
>> >But this won�t work, as the data source of the Invoice Headers subform
>> >includes fields from other tables and tells me it is not updateable.
>>
>> You might be able to use Albert's Multi Select stuff at:http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
>>
>

>Thanks Marsh, my subform is a datasheet but I'll check out the the
>code you suggested which is designed for a continuos form.

Changing a datasheet form to a continuous form is no big
deal and continuous forms have many more features you an
use. I have never used a dataheet form in a real
application.

--
Marsh