Update Auto Number when data is entered on subform

  • Thread starter Thread starter Mya48
  • Start date Start date
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
 
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
Click to expand...

I would generally lock or hide the subform until the BeforeInsert event
of the main form. Then they are forced to make an entry on the main form
before they can make a subform entry.

Barring that I just tell them "don't do it that way you moron".
 
How would I hide the subform named Placed_Orders_Subform until the control
named Section is populated if the control is a drop down list?
 
Back
Top