A
arran1180
Ok heres my setup;
i have a subform displaying recirds from query1. In design view i have
added the code on the dblclick - DoCmd.OpenForm "frm_manual_entrys" so
that when the subform is viewed, you can double click and the
frm_manual_entrys opens.
This form is an input form for another table - tbl_manual - and has record
source set to this table.
I have set the default values in the form to those in the subform, so that
the form is populated when you open it with the double click. (aprt from a
field which has an equation..)
So far so good - problem is the form refuses to update the table! i am using
a standard cmd button to add new record, and the forms properties are set to
data input. Any ideas what to look for ?? I want users to be able to pick a
record from the subform and by double clicking open a form to input data into
another table, and that data will be auto populated from the data in the
subform....
help please!
i have a subform displaying recirds from query1. In design view i have
added the code on the dblclick - DoCmd.OpenForm "frm_manual_entrys" so
that when the subform is viewed, you can double click and the
frm_manual_entrys opens.
This form is an input form for another table - tbl_manual - and has record
source set to this table.
I have set the default values in the form to those in the subform, so that
the form is populated when you open it with the double click. (aprt from a
field which has an equation..)
So far so good - problem is the form refuses to update the table! i am using
a standard cmd button to add new record, and the forms properties are set to
data input. Any ideas what to look for ?? I want users to be able to pick a
record from the subform and by double clicking open a form to input data into
another table, and that data will be auto populated from the data in the
subform....
help please!