Pop up form or subform: which is best?

[Robert Robinson]

The table that I am designing will require a "Discount" field. The office
manager wants the data entry person to have an option of directly entering a
dollar amount, or entering a percentage that will calculate against the
"Cost" field and then enter the resulting discount in the "Discount" field. I
am comfortable in generating the code to perform the calculation. My question
is which would be the best process to use:
1) Create a pop up form that appears when the "Discount" field is entered, or
2) Create a subform?
From my limited knowledge, it seems that a pop up form would do it, but I am
not sure if there are more benefits from using a subform. Thanks.

 

[John W. Vinson/MVP]

The table that I am designing will require a "Discount" field. The office
manager wants the data entry person to have an option of directly entering
a
dollar amount, or entering a percentage that will calculate against the
"Cost" field and then enter the resulting discount in the "Discount"
field. I
am comfortable in generating the code to perform the calculation. My
question
is which would be the best process to use:
1) Create a pop up form that appears when the "Discount" field is entered,
or
2) Create a subform?
From my limited knowledge, it seems that a pop up form would do it, but I
am
not sure if there are more benefits from using a subform. Thanks.

Why use EITHER? Can't you just use an unbound textbox on the Form, and use
its AfterUpdate event to do the calculation?

A popup form is useful when you need to edit or view a completely different
unrelated table; a Subform is best when you need to edit or view multiple
records in a "child" table related to your current table.

John W. Vinson/MVP