M
Mya48
I have a main form that has an auto number and department name. On this form
there is a subform where you can pick the products you would like to order.
My problem is that if someone skips the department name and goes straight to
the subform to enter data, then goes back and selects their department, their
order details dissapear and they have to re-enter it all over again but the
order details get populated anyways into the subform table without tying it
to this order.
I would like for the form to assign the Auto Number if someone picks their
department name right away or if they go directly to the subform and enter
their order details.
Thanks
there is a subform where you can pick the products you would like to order.
My problem is that if someone skips the department name and goes straight to
the subform to enter data, then goes back and selects their department, their
order details dissapear and they have to re-enter it all over again but the
order details get populated anyways into the subform table without tying it
to this order.
I would like for the form to assign the Auto Number if someone picks their
department name right away or if they go directly to the subform and enter
their order details.
Thanks