Search results

  1. R

    Event Procedure Error Combo-box query update

    Earlier today I copied a working form to create 2 variations. It has combo-boxes which requery following the update of another box. The update event procedure isPrivate Sub Division_AfterUpdate() Me.SalesManager = vbNullString Me.SalesManager.Requery Me.CostCentre = vbNullString...
  2. R

    Query Prompting for data when it has all arguments

    I've created a query using design view in Access 2011. Part of it has 2 expressions (Sales and Cost) that i then need to find the difference of. I have done this with a third expression, GrossProfit. For some reason when running the query Access prompts for the value of Sales and Cost, but in...
  3. R

    Diplaying Specific Totals from a Subform/table on the Parent Form

    Hi all, I'm building a form. It's based upon a table "Orders", within this is an "Invoices" subform (Datasheet). Each entry in the subform has a type (text) and a value (currency). My aim is to display to the totals at the bottom of the parent form in a text box. The catch is I need 3...
Back
Top Bottom