Search results

  1. W

    A field from last record to auto enter into a field in a new record

    I'm looking to do a simple inventory where what comes in (form 1) and what goes out (form 2) are taken away to leave a total. This total needs to be added to the next 'what comes in' form when new inventory is recorded. Is it possible to have a vba or something that can take the last field...
  2. W

    me.form.field.value =

    Hello, I am trying to send data from one form to another to a certain field an afterupdate VBA, and it send it just fine. However the trouble is when field 2 has the same formula (though it's going to a new field in the said form) it goes to a new record, which is not what I need it to do. I...
  3. W

    Send data from one form to another

    I was using this code: Private Sub Delivery_Date_AfterUpdate() Me.InventrySub.Form.InV_Date.Value = [Delivery_Date] End Sub and it was working. now it isn't. Can't figure out why. This happened after I did a compact and repair.
  4. W

    VBA afterupdate help

    Hello, I currently creating a DB to sum fields and place them in a db field. Which is working kinda fine until.. Private Sub VIP_Pcs_AfterUpdate() Me.Total_Pcs.Value = Me.PcsTot Me.Tax_Amt.Value = Me.TaxSum Me.Bling_Total.Value = Me.BlgTot Me.Refresh End Sub I have 3 other afterupdate fields...
  5. W

    It's a Combo Box Question Again!

    I have been looking around this site to find the answer I seek, but to no avail. This is my dilema. I have three (3) combo boxes, [Product],[Paper Grade], and [Print Color]. Each choice displays another value in a corrisponding list (i.e. Product Name displays: Product and Layout Fee, for the...
Back
Top Bottom