filtering and edit

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Damon Grieves
    #1

    filtering and edit

    Hi
    I have a large table which I wanted to filter and then edit the selected
    record.
    I'm using a form with several pull down fields linked to lookup tables which
    correspond to fields in the large table. The user selects a number or
    category or All from the pull-down and this is used in a query, made up of
    the main table and the lookup tables with a suitable Iif statement to filter
    the query.
    So on the form there are several fields that can be each set to a value or
    to All. A button runs the query if no pulldowns are selected each field
    defaults to All and all the records are displayed.
    The form can filter as one field only or A And B And C etc. This works well
    and gives the filtered subset displayed in the subform on the form.
    Is there now a way to edit a selected record from the few in the subform?
    Maybe dbl/click on it and search for that record and display to a pop up
    window.
    Is there an easier way to achieve all this?
    TIA



    Tags: None
    • Tom van Stiphout
      #2
      Re: filtering and edit

      On Wed, 7 Dec 2005 23:07:33 +1100, "Damon Grieves"
      <damong@vfeNOSP AMmail.net> wrote:

      The mere act of filtering (this term has specific meaning in Access)
      does not make a recordset readonly.
      Take a Northwind form.
      Observe it is editable.
      Use filter by form to filter on some criteria.
      Observe it is still editable.

      If you set the form's Filter property to some "Where Clause", it does
      not become uneditable.

      Perhaps you're doing something different. Please elaborate.

      -Tom.

      [color=blue]
      >Hi
      >I have a large table which I wanted to filter and then edit the selected
      >record.
      >I'm using a form with several pull down fields linked to lookup tables which
      >correspond to fields in the large table. The user selects a number or
      >category or All from the pull-down and this is used in a query, made up of
      >the main table and the lookup tables with a suitable Iif statement to filter
      >the query.
      >So on the form there are several fields that can be each set to a value or
      >to All. A button runs the query if no pulldowns are selected each field
      >defaults to All and all the records are displayed.
      >The form can filter as one field only or A And B And C etc. This works well
      >and gives the filtered subset displayed in the subform on the form.
      >Is there now a way to edit a selected record from the few in the subform?
      >Maybe dbl/click on it and search for that record and display to a pop up
      >window.
      >Is there an easier way to achieve all this?
      >TIA
      >
      >[/color]

        Comment

        • GH
          #3
          Re: filtering and edit

          If the form's Allow Edits property is set to No, you would not be able
          to edit the record. If the subform includes any aggregate functions or
          is missing any required fields from the underlying table, the filtered
          records would not be editable regardless of the form settings. These
          are the only specific scenarios I can think of off the top of my head
          that would prevent edits in a subform.

            Comment

            • John Welch
              #4
              Re: filtering and edit

              It sounds like you might be able to save yourself lots of work by just
              making a main form that shows all relevant fields of your table, and then
              using filter by form to find selected records to edit. Do you have special
              requirements or complications that prevent you from doing it this way?

              "Damon Grieves" <damong@vfeNOSP AMmail.net> wrote in message
              news:4396d191$0 $6195$afc38c87@ news.optusnet.c om.au...[color=blue]
              > Hi
              > I have a large table which I wanted to filter and then edit the selected
              > record.
              > I'm using a form with several pull down fields linked to lookup tables
              > which
              > correspond to fields in the large table. The user selects a number or
              > category or All from the pull-down and this is used in a query, made up of
              > the main table and the lookup tables with a suitable Iif statement to
              > filter
              > the query.
              > So on the form there are several fields that can be each set to a value or
              > to All. A button runs the query if no pulldowns are selected each field
              > defaults to All and all the records are displayed.
              > The form can filter as one field only or A And B And C etc. This works
              > well
              > and gives the filtered subset displayed in the subform on the form.
              > Is there now a way to edit a selected record from the few in the subform?
              > Maybe dbl/click on it and search for that record and display to a pop up
              > window.
              > Is there an easier way to achieve all this?
              > TIA
              >
              >
              >[/color]


                Comment

                Previous template Next
                Working...