How do i copy data which is displayed in subform(From a query) to paste it in main form(With Table restrictions for "required")
How do i copy data which is displayed in subform(From a query) to paste it in main form(With Table restrictions for "required")
normally you dont need to since you already see it in the subform, but
you can use the full path to the object ...(use the BUILDER to get the path correct)
me.txtBox1 = me.subform.form.txtBox2
or use an update query using the key on the master form:
update [masterTable],subtable set masterTable.[field] = subtable.field where masterTable.Key = forms!myForm!txtKey
Id use the code version instead of the query.