A
Achieva
I had a form "frmCustomerInvoice" that had a command button that opened a
form "frm Orders" for either viewing or adding (depending on need). Works
fine
I designed a new form "frmCustomerInvoice2" with a subform "child30"
(frmOrders) linked on "customerId". Viewing and editing all of my old
records are fine. The problem is adding a new record (add mode). When I try
to open the form in "add mode" (record 1), I have an empty master record
(with the fields ready to accept my data). The subform (frmorders2) is
totally blank (not empty... blank). When I try to tab into the form from my
last field on the parent form using OnExit event of
"Forms!frmCustomerInvoice!Child30.SetFocus" and then a doCmd to go to a
control, I get an error message of no such field. The Child30 subform stays
blank (grey). I have tried different property settings on the subform (allow
additions, etc).
form "frm Orders" for either viewing or adding (depending on need). Works
fine
I designed a new form "frmCustomerInvoice2" with a subform "child30"
(frmOrders) linked on "customerId". Viewing and editing all of my old
records are fine. The problem is adding a new record (add mode). When I try
to open the form in "add mode" (record 1), I have an empty master record
(with the fields ready to accept my data). The subform (frmorders2) is
totally blank (not empty... blank). When I try to tab into the form from my
last field on the parent form using OnExit event of
"Forms!frmCustomerInvoice!Child30.SetFocus" and then a doCmd to go to a
control, I get an error message of no such field. The Child30 subform stays
blank (grey). I have tried different property settings on the subform (allow
additions, etc).