accessing a row from a sub table

[Dan]

I am designing an accounts receivable form and I have it
so that there is a subsheet where the users enters the
amount due, date and the amount paid into a datasheet
form. I need it so that the user can send out a bill for
a certian date with the specified amount due. What would
be the best way to go about this?

 

[John Vinson]

I am designing an accounts receivable form and I have it
so that there is a subsheet where the users enters the
amount due, date and the amount paid into a datasheet
form. I need it so that the user can send out a bill for
a certian date with the specified amount due. What would
be the best way to go about this?

Use a Form with a Subform, and enter the date into the subform; base
the bill on a Query selecting the desired date.

I'm not sure just what problem you're having!