Dynamic Pricing Application

[Kenneth Grice]

I have a table that includes a base price. The user will use a search
form to finally get to that base price for a particular product.
Here is the part I can't figure out:

I have a table that includes additional options for the item with the
price.
These are in another table called Options.

I was wondering what was the easiest way for the user to select what
options they want and add the total of these additional options To The
BASE PRICE.

I tried to even let the user type in the price inside a text box by
seeing the Options in a subform. But the user can then change some of
the data since the form would have to be in Edit Mode.
I would appreciate any help.

Thanks

[Wayne Morgan]

Use a 3 column, multiselect list box. The first column would be hidden and
would have the ID of the option. Columns 2 and 3 would have the description
of the option and the price. You would add the values of column 3 from the
selected rows to the base price.

--
Wayne Morgan
Microsoft Access MVP
"Kenneth Grice" <ke**********@yahoo.com> wrote in message
news:e2**************************@posting.google.c om...

I have a table that includes a base price. The user will use a search
form to finally get to that base price for a particular product.
Here is the part I can't figure out:

I have a table that includes additional options for the item with the
price.
These are in another table called Options.

I was wondering what was the easiest way for the user to select what
options they want and add the total of these additional options To The
BASE PRICE.

I tried to even let the user type in the price inside a text box by
seeing the Options in a subform. But the user can then change some of
the data since the form would have to be in Edit Mode.
I would appreciate any help.

Thanks