Autofill subform fields from a main form field
Posted: Sun Jan 08, 2017 12:45 am
Hello,
I'm totally lost with 2 issues, reason for which I required you help.
1. I have a main form with unbound fields and a subform (with this I'm writing data in tbl). What I'm doing is to call in a subform field, a data from main form. I did like that: On an "save" button I add the code - Forms!Invoice![Products_invoice subform].Form![number] = Me!Invoice_number.Value
The problem is that, if I have multiple lines filled in subform, the value is completed only in selected line and not in all of them. How can I call the "invoice_number" in all the fields / lines filled?
2. Let's assume that I have a main form (frm1) and 3 tables (tbl1, tbl2 and tbl3). In the frm1 I called some data from tbl2. How can I save data in tbl3, from tbl1 if the info does not exists in my form? Can you please help me with specific explanations?
Thank you,
Adriann
I'm totally lost with 2 issues, reason for which I required you help.
1. I have a main form with unbound fields and a subform (with this I'm writing data in tbl). What I'm doing is to call in a subform field, a data from main form. I did like that: On an "save" button I add the code - Forms!Invoice![Products_invoice subform].Form![number] = Me!Invoice_number.Value
The problem is that, if I have multiple lines filled in subform, the value is completed only in selected line and not in all of them. How can I call the "invoice_number" in all the fields / lines filled?
2. Let's assume that I have a main form (frm1) and 3 tables (tbl1, tbl2 and tbl3). In the frm1 I called some data from tbl2. How can I save data in tbl3, from tbl1 if the info does not exists in my form? Can you please help me with specific explanations?
Thank you,
Adriann