Search results

  1. L

    Passing value of DSum to text box after combo box update

    Hi, I have a combo box that has a list of names in it. When I select a name, I am wanting to DSum a column in one of my tables based off of the name in the combobox and pass the value to a specific text box. The below code has worked in another database that I have set up but it is for 2010...
  2. L

    Updating Multiple Text Boxes under one Event

    Hi, I am trying to figure out how to trigger the below VBA Code under one Change() Event once a selection is made from the only combobox on my form. Can anyone help me with this? Private Sub cbxAssociate_Change() Me.txtFIRJuly14.Value = DAvg("FIR_Perc", "tblFIRStats", "[Associate]= '" &...
  3. L

    Form With Two Comboboxes - DAvg

    Hi, Can anyone tell me what I am doing wrong with the below SQL statement? I am writing this so that when a selection is chosen from each of the combo boxes (Name and Month/Year) then it will look back at a table and perform an average on a specific field. To achieve this, right now, I have...
Top Bottom