Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004

    Unanswered: Limiting items showing in Form

    I am trying to use a form that uses a table for its record source (so I can edit the table). At the same time, I would like to limit the items showing in the form to a list resulting from a query. Any ideas?

    Query: qryEMRevenueForecast
    Form: EMRevenueForecast
    Table: Forecasts

    Hope you can help!


  2. #2
    Join Date
    Feb 2004
    Use the query as the data source - As long as you allow the edits/deletions etc in the properties you should be able to update the values - Assuming it's not grouped or a crosstab query.

    Try it, open the table and the records to have changed should be as per your adjustments.

    I have used this to show records within value ranges or by user etc

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts