Math in a field and storing the values in a field.

[gene_yuss]

I have a Pricing Table, different Customers have different pricing and the end user selects a "Format", like large print or braille, based off a combo box.


Is there a way to have Access pull the correct price per customer based off the dropdown?

Any ideas or links would be great.

[June7]

Yes, requires code (macro or VBA, I use only VBA). Data entry must be on a form, not directly to table (unless maybe a data macro can be coded to do this, I haven't used data macros). If the price field you want to save value to is part of the form's RecordSource, in combobox AfterUpdate event, could simply be:

Me!Price = Me.comboboxname(0)

Combobox column index starts with 0 so column 1 is index 0. If the price is in a column of combobox then reference that column by its index.

[gene_yuss]

I tried to impalement that without thinking it through. Your advice about how to pull this off would be great.

Customer Name	Customer ID	Process And Redirect Price	Logging Markup Per Page	Markup % Per Page	Large Print Price/Page	Braille Pages Price/Page	Braille Translation Price/Page	Emboss_GFX Price/GFX	PrintingCostPerMin	AudioTapeCostPerMin
Recipient	1				$6.50	$1.60	$6.50	$1.60	$0.25	$1.60

so the value of a field would change depending on what "format" is on the invoice. I dont see a way to do this without altering my table.

Product Format	Comment
Audio Tape	Audio tape product format
Braille	Braille product format
CD	Compact Disc/DVD format
Diskette	Computer diskette product format
Email	Email product format
Large Print	Large Print product format
Oral Presentation	Material should be orally presented
Process Redirect	Process Redirect format
Special Project	Category for future additional formats

[June7]

Can you provide project for analysis?

[gene_yuss]

Can you provide project for analysis?

You bet. Anything you could help with. I have three things to finish by tomorrow or we aren't going to make payroll. I appreciate the time you spend on the forums. Many of your posts have helped me. Thanks in advance.

[June7]

Hope this issue has nothing to do with payroll deadline because it is already late and I need more info.

I don't really understand how Product format impacts pricing.

If user selects Email, how does that factor into the price of Computing/Taping Time or Materials Used or Other Services or Shipping?


Also, why is the DefaultValue for Computing/Taping set to Minutes;Labor? These are two rows in the combobox list.

Are you printing form as invoice instead of creating a report to do this?