Record source problem

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

    Record source problem

    Hi



    I Saved As... a form to another name and change the new forms data source.
    The problem is that the new form does not show any data with the new data
    source. I have tried compact & repair and decompiling but no luck.
    Eventually I had to put in the form load event the command
    DoCmd.RunComman d (acCmdRemoveFil terSort) to make the form show any data. Why
    would the form have a filter attached to it so stubbornly?



    Thanks



    Regards


    Tags: None
    • Rick Brandt
      #2
      Re: Record source problem

      John wrote:
      I Saved As... a form to another name and change the new forms data
      source. The problem is that the new form does not show any data with
      the new data source. I have tried compact & repair and decompiling
      but no luck. Eventually I had to put in the form load event the
      command DoCmd.RunComman d (acCmdRemoveFil terSort) to make the form show any
      data. Why would the form have a filter attached to it so stubbornly?
      Does the new RecordSource have all the same field names? If not you have to
      change the ControlSource property of all your controls to the new field names.

      --
      Rick Brandt, Microsoft Access MVP
      Email (as appropriate) to...
      RBrandt at Hunter dot com


        Comment

        • John
          #3
          Re: Record source problem

          After reassigning record source I reassigned fields as well so they are OK.
          Also it works if I use the remove filter command either in vba or manually.

          Regards


          "Rick Brandt" <rickbrandt2@ho tmail.comwrote in message
          news:1bCKg.5131 $tU.1958@newssv r21.news.prodig y.com...
          John wrote:
          >I Saved As... a form to another name and change the new forms data
          >source. The problem is that the new form does not show any data with
          >the new data source. I have tried compact & repair and decompiling
          >but no luck. Eventually I had to put in the form load event the
          >command DoCmd.RunComman d (acCmdRemoveFil terSort) to make the form show
          >any
          >data. Why would the form have a filter attached to it so stubbornly?
          >
          Does the new RecordSource have all the same field names? If not you have
          to change the ControlSource property of all your controls to the new field
          names.
          >
          --
          Rick Brandt, Microsoft Access MVP
          Email (as appropriate) to...
          RBrandt at Hunter dot com
          >

            Comment

            • Rick Brandt
              #4
              Re: Record source problem

              John wrote:
              After reassigning record source I reassigned fields as well so they
              are OK. Also it works if I use the remove filter command either in
              vba or manually.
              If you see records when you use "remove filter" then the reason you don't see
              records is because of a filter beking applied. Most likely you have the
              DataEntry property set to true.

              --
              Rick Brandt, Microsoft Access MVP
              Email (as appropriate) to...
              RBrandt at Hunter dot com


                Comment

                Previous template Next
                Working...