Hi everyone. Got a question...
I have two forms, which are identicle to one another, except one is a "Quote" Form and the other is an "Invoice" form. These forms have a sub form on them.
After i have filled out a Quote form and want to make an invoice of that form what i have done is put a command button on the quote form which opens the invoice form and pastes the the info from the quote from to the invoice form, as to reduce redundant typing. I acheived this by on the form "Load" of the invoice form i simply set the the text boxs of the two forms equal to each other. Every thing works great except the sub form on the invoice form will only pull over the first record of the subform on the quote form, even though there is more than one record.
Is there anyway that i can get the subform on the invoice form to display all the corresponding info that is in the subform of the quote form?
I feel like a loop is involved?
What do you think?
VAV
I have two forms, which are identicle to one another, except one is a "Quote" Form and the other is an "Invoice" form. These forms have a sub form on them.
After i have filled out a Quote form and want to make an invoice of that form what i have done is put a command button on the quote form which opens the invoice form and pastes the the info from the quote from to the invoice form, as to reduce redundant typing. I acheived this by on the form "Load" of the invoice form i simply set the the text boxs of the two forms equal to each other. Every thing works great except the sub form on the invoice form will only pull over the first record of the subform on the quote form, even though there is more than one record.
Is there anyway that i can get the subform on the invoice form to display all the corresponding info that is in the subform of the quote form?
I feel like a loop is involved?
What do you think?
VAV