Hi there,

I have designed a database for a library. To display books
that a borrower has on loan i have designed a form with a
text box, command button and label. When you insert a
Borrower Number into the text box and click on the command
button the books on loan for that person are displayed in
the label. As i'm sure you know this is done via
recordsets. Now i want to embellish the label and display
the contents of the recordset in datasheet view. How would
you suggest i do this?

Thanks in advance

Martin

You could use a datasheet view of a subform. There is no code required if
you set the link master/child properties of the subform to the
BorrowerNumber.

--
Duane Hookom
MS Access MVP


"placek" <(E-Mail Removed)> wrote in message
news:827001c3e8f4$cb7347e0$(E-Mail Removed)...
> Hi there,
>
> I have designed a database for a library. To display books
> that a borrower has on loan i have designed a form with a
> text box, command button and label. When you insert a
> Borrower Number into the text box and click on the command
> button the books on loan for that person are displayed in
> the label. As i'm sure you know this is done via
> recordsets. Now i want to embellish the label and display
> the contents of the recordset in datasheet view. How would
> you suggest i do this?
>
> Thanks in advance
>
> Martin
>
>