Form / Subform add NEW

[brutuss100]

Hi everyone,

I have a Purchase Order (PO) Generator that allows my users to add anywhere
up to 25 items to an order (using individual subforms called up from the Main
form). Sometimes it's easier to copy the current record and make a few little
changes to any of the items, then it is to retype all items (especially the
more items there are). I would like to be able to duplicate the Main form as
well as all of the Sub forms associated with it when duplicating a PO. I know
that there is a way to do this using the Tag Property for the sub forms, but
I'm having difficulties getting the subs to duplicate. "What" goes "Where"?

Can anyone help?

 

[NoodNutt]

G'day Brutus

I'm a little confused as your form doesn't sound rational.

Are you saying that each time a user selects a different item/product to
place in the newly created OrderNo you open a different subform? or am I
reading it wrong!

If indeed you do have multiple subforms for each individual item then would
it not be simpler to add a combo into the first subform for user to select
from. This would then reduce your OrderID to just the single instance
PrimaryKey in your Main tblOrders and all the item information relative to
that Key would be matched by the ForeignKey in your tblOrderInfo.

You could have a combo on your main form that selects a product category,
which would in-turn filter the combo in your subform to return all the
items/products that match the category.

This way users can enter as many items/products across multiple categories
on a single order without the need to duplicate the order.

If all of the above is incorrect, then clarify when re-posting with a
specific layout of your form, including all the subforms and any codes that
are underlying.

HTH
Mark.