creating invoice

[kymay]

i am trying to complete a form/invoice. on this invoice i may sometimes have multiple lines. for example, i may have one item on this invoice but the next invoice may show 10 items. how do i get the subform i have created to allow this. i understand the calculations and have that set. i just need the form to allow more than one "line" on the invoice for what is purchased.

 

[jeremie_ingram]

If I understand, I think what you need to do is set the subform up for datasheet view. Check out the example and let me know if its what you mean.

 

[kymay]

invoice

this is what i had done, now that i am thinking and working more with this--at least i know i am not basically wrong. my problem may be with the table i created for this form. i will continue to work with this and see how i do. i may post more questions on this matter later. thanks.

i do have a question with the same database, but on a different line.

when i change my combo box information the linked subform mailing address (in this same invoice) will not change until i close the form or minimize it. when i open or maximize the form all my info is correct. i have worked with several different areas in the properties within the subform, yet still i cannot get the correct operation. i should select the shipper from a combo box and i thought that immediately the information would change. this information is just not switching like i think it should.

thanks for your help!!!

 

[jeremie_ingram]

You could try the after update property of the combo box and set it to refresh the subform.