help with Pop-Up form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a frmorders that I use to place new orders, when the user selects the
type of order to place, a unique ordernumber is assign, and then the user
enters information/details about the order.

Sometimes, I need to produce a sample of the order before the order is
actually placed, so .. what I would like to do is have a box "Produce Sample"
and have it as a checkbox or command button the user presses.

Then a new form "pops-up" and takes the ordernumber, and details and
populates the frmordersample and adds this as a new record to tblorders. But
what I am trying to do is when the ordernumber is populated on the
frmordersample, it adds "Sample" to the ordernumber. For example if the
ordernumber is "00-0001" then when the frmordersample pops up, it creates the
ordernumber "00-0001 Sample"

Can anyone help me set this up?

Thanks,

Brook
 
A cleaner approach would be to add a field to your table to identify sample
orders. I would suggest a Yes/No field. It would make filtering much easier.
 
Back
Top