Price Selection Question for Form

[Meredith9053]

Hi All,

Little drama. Cant work it out.

Have product list with two price colums. List Price, and Bulk Price.
Would like to also have a "Blank" price, so that it can be added on the
occasion that specials exist etc.

At present, I have a form that has a drop down for the product name, then
once selected it inserts the description in the description box. Would also
like to go into the unit price and have a drop down list to select either,
the predefined (from Products table) List Price or Bulk Price, or if I select
the blank price, I can enter my amount I choose.

From there the product name, description qty and unit price are in my report
(much like an invoice.)

I realise that it would be easier, to just default prices to 0.00 in
products table but reluctant to do that, because its more work, and adds the
human error element.


One Other thing - sorry to be a pest -

Have Qty Ordered, Qty supplied on my form. What to see if I dont enter a
qty ordred amount, that the qty supplied amount will be put in automatically.
(most of the time, the ordred is same as supplied, but obviously on
occasion, stock is not at hand.)

Thanks so much.
Meredith

 

[Mr B]

Meredith,

Sounds like you need some way to specify the type of pricing. You might
consider adding a group control with three options;
1-List Price; 2-Bulk Price; 3-Special

You may want to specify the List Price as the default or whatever.

Then depending on the options selected either change the source for your
combo box to have it provide the List Price or the Bulk price, or if the user
selects the "Special" pricing type, then you would disable the combo box
available and set focus to it to make the text box available where the
Special price could be entered.

If you need additional assisance, please just post back.

 

[Meredith9053]

Thanks "Mr B"

Shall consult my books to add a group control. appreciate the heads up.

Any dramas and I will post back.

Cheers
Meredith

p.s. would you mind having a look at my other query? This same post, the
paragragh under "one other thing". Thanks so much.

 

[Meredith9053]

Hi again "Mr B"

Ok, have sonsulted my books looking up group control. It is not helping me!
could I please adk for your assistance.

Here are some things you may need to know.

Running Access 2007

Have Products table with normal fields, like part number desc etc. Have, as
posted before, SpecialPrice, BulkPrice and ListPrice. Have set amounts for
Bulk and List and special was for a varied price that might happen from time
to time.

in my form I have a combo box on part number which, when product is selected
it selects description to be added automatically. Unit Price is set at 0.00
default currency.

Can you advise how to add group control for pricing that will solve my price
selection issues?

Thinking this may be all to hard, and wondering what deterement it would
have to database if no prices are in it. ie, each order has pricing entered
at the time? One other thing, when the price changes, ie increases yearly, i
cant just change amount can I, or all the old orders would be cascaded with
that pricing. Or is it a matter of just switching off cascading updates?

Thanks for you time. Hate to be a nusience, but dont want to wreck all the
work that i have done thus far.....

Cheers
Meredith