Help With Purchase Order Form

[pbaldy]

For starters, the other fields have to be included in the row source of the combo (they don't have to be visible). Don't forget to adjust the column count of the combo if you modify the existing combo. Second, your code wasn't associated with the combo. You want to click in the after update property of the combo, then on the ellipsis (...). Third, x is the column number, not the name:

Me.TextTest = Me.ComboTest.Column(1)

[SpeedyApocalypse]

That worked fantastically! Thank-you SO much! I'm sorry I couldn't grasp it for so long

[pbaldy]

No problem, glad we got it sorted out.

[SpeedyApocalypse]

Now, I have actually 2 more questions, but I will try to get the most important one sorted out first. If you refer to my picture in the first post, you will see that I had a section for "Amount" in my purchase order. How would I be able to add up all of the values in the Amount column (I would have about 10 different text boxes, and access would add them up) and then how would I add them together, put the output in the subtotal box. Then apply math to find the taxes, then apply math for the final total? All I really need to know is how do I link the values in the text box together via math and have various outputs into other textboxes?

I would have my format as Currency on the text box, all I really need to know is how to add values together from text box to text box and have the final product output into another textbox?

[pbaldy]

You should be able to sum the amount field with a textbox in the footer:

=Sum(AmountField)

Other textboxes can refer to that one to use the total.

[SpeedyApocalypse]

Sorry, I am very new to access.

Would you be able to give a step by step sort of guide to add the values in my text boxes together and then putting the sum into another text box?

I really would need step by step here as I do not understand most terminology

[pbaldy]

Did you try what I suggested? Put a textbox in the footer. Give it the control source I mentioned, using your field name.

[SpeedyApocalypse]

The textbox has to be in the main field of my form, it can't be in the footer >.<

[pbaldy]

Have you made the normalization mistake of having multiple amount fields in the same record? If so:

=Amount1 + Amount2 + Amount3

[SpeedyApocalypse]

Aha! That worked fantastically for all of the math in my form. Thank-you so much! On some of the purchase orders, PST would be optional, could I code a check box to allow PST to be added into the final total?

[pbaldy]

Sure, a "Taxable" checkbox would be an appropriate solution. You could then use an IIf() function (or an If/Then block in code):

IIf(Taxable = True, Amount * PSTRate, 0)

[SpeedyApocalypse]

EDIT: In the addition command that you gave me also, it now gives no output if there is no value in a textbox. How can I make it so it will still add them all up and ignore null values?

I didn't quite understand that.

Where would I put that statement? Under onClick then expression builder, or is it VBA code?

I have a GST field that is used 100% of the time. My Final Total textbox adds up the Sub Total field (named "sub"), the GST field (named "gst") and the PST field (named "pst"). The final total field name is "total". I need this checkbox to simply remove all value from the PST field (if it is displaying $10.00 before the checkbox is checked, as soon as it is checked, it would just be left blank, then, as soon as the checkbox is unchecked, it would return to its original value). Would a checkbox be able to do that? If so, could you possibly set it up for me as I have listed the names of the text boxes that would possibly be used in this procedure?

Thanks again, I would be still at square 1 without you

[pbaldy]

To have the checkbox do it, you'd use its after update event:

If (Me.CheckBox) Then
  Me.PSTField = YourCalculation
Else
  Me.PSTField = 0
End If

To handle Nulls (empty fields), you can use the Nz() function.

[SpeedyApocalypse]

That would work great, and I have it set up, except, the PST text field is set up as a control source and it cannot have a value added to it. Is there any way to make it editable whilst I have it as a control source?

EDIT: Nevermind, got that working in the most roundabout way ever.

[SpeedyApocalypse]

How would I make my math on the sub total text box (sub total adding up 15 amount text boxes), ignore text boxes with nothing in them and just add up as if they had 0's in them. Pretty much, I need the sub total text box to think of null values as O's. Could you perhaps present me with a line of code for this?

The amount textboxes use 2 other fields to get their value, so I couldn't have it auto display $0.00.

EDIT: Got the Nz Function working, everything is great now. All I need is a button that can save the form as a PDF and I am done