Search results

  1. V

    Order Form referencing two fields in table

    Hello, I have am setting up a new database to track orders. I have a table containing the product name and also a SKU. When placing an order I want the user to be able to select either a product or a SKU from the list and the other field to be automatically populated with the corresponding...
  2. V

    Query to show Orders for next upcoming Sunday

    Hello, I am looking to create a query that can show all orders for the next upcoming Sunday and not by date. Is there a way of doing this ? I can filter by date no problem but I want it to be by day and only the next upcoming Sunday not previous ones. Thanks,
  3. V

    AfterUpdate only editing first record

    Hi All, I am very inexperienced on access but have set up a small database to assist with my business. I have an AfterUpdate event where when I alter a textbox on my main form it recalculates a column in a subform. It is working however it is only recalculationg the first record and not the...
  4. V

    Calculated Field AfterUpdate Help in Form

    Hi, I have a form that has a calculated text box. It works out a sell price for the product and it is set to update after the Cost Price field is updated. The calculation works great however it is changing the text box for every record in the form (In tabular view). Is there a way to only...
Top Bottom