help with Pop-Up form?

[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

 

[Guest]

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.

 

[Guest]

Thanks...

After the post... I started thinking about an easier method.

Brook

 

[Guest]

Great! Easy is good.

Thanks...

After the post... I started thinking about an easier method.

Brook