Search results for query: *

I finally got it to work!! What I did was I made a text box to contain the value I want to be totaled for each field (using an iif statement), and then in the total field, I added up those fields. It's probably the hard way... but at least I got it to work!

It didn't work. I then tried after setting the value for a, b, c, etc. to add the variables up to that point and that doesn't work either.

Here's my code: Dim A As Integer Dim B As Integer Dim C As Integer Dim D As Integer Dim E As Integer Dim F As Integer Dim G As Integer Dim H As Integer Dim I As Integer Dim J As Integer Private Sub txtAA_BeforeUpdate(Cancel As Integer) If txtAA = 1 Then C = 5 Else C = 0 End If txtTotal...

I have all together 10 fields that I want to add. I tried doing the "Before Update" method and for some reason, the Total field only shows the value I set for the field I just updated. I have 2 fields that when the value is 0 should give Total a different value and when I load the...

I'm trying to create a total field using data from other fields, but assigning different values to those values: field1: if the value entered is 0, I want 2 to be added to the total. field2: if the value entered is 0, I want 5 to be added to the total. How can I do this? Thank you for your help!

I did make a query, but when I view the query, all I see are the headings. Does it matter that I don't have any data entered into the tables? The form is set up as a single, continuous form. Thanks for your help!

Is there any way that I can create a form using multiple tables and be able to enter data in form view? I am able to get all the fields onto the form in design view, but for some reason when I switch into Form View, nothing shows up (it's just a blank page). Please help me! Thanks!