access2007 combo stops filtering

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

    access2007 combo stops filtering

    Hello All,
    I've bee trying out access 2007 and have a weird issue and would like
    to see if I'm issing something really basic.

    I have a form based on a query, I create a combo to look for records
    on my form based on Org_ID. Wgen I create all is fine - I type e,
    combo goes to e and starts filtering etc just like normal......I save
    the form, close the database and when I re-open the combo doesn't
    respond to any input - I can select a record and the form finds the
    record, but if I try to type in the combo nothing happens.

    I have the db in a trusted folder, I have reverted to letting access
    create the combo with embedded macro (just trying to see if it's a
    code issue) - SP1 is installed....ma cros are allowed...
    Totally frustrated and would appreciate any guidance if anyone has
    resolved the same issue.

    Thanks
    John
    Tags: None
    • Tom van Stiphout
      #2
      Re: access2007 combo stops filtering

      On Wed, 5 Mar 2008 04:26:08 -0800 (PST), flymo <fly_mo@hotmail .com>
      wrote:

      Can you reproduce this with the dropdown in the Northwind login form?
      Is AutoExpand set to True?

      -Tom.

      >Hello All,
      >I've bee trying out access 2007 and have a weird issue and would like
      >to see if I'm issing something really basic.
      >
      >I have a form based on a query, I create a combo to look for records
      >on my form based on Org_ID. Wgen I create all is fine - I type e,
      >combo goes to e and starts filtering etc just like normal......I save
      >the form, close the database and when I re-open the combo doesn't
      >respond to any input - I can select a record and the form finds the
      >record, but if I try to type in the combo nothing happens.
      >
      >I have the db in a trusted folder, I have reverted to letting access
      >create the combo with embedded macro (just trying to see if it's a
      >code issue) - SP1 is installed....ma cros are allowed...
      >Totally frustrated and would appreciate any guidance if anyone has
      >resolved the same issue.
      >
      >Thanks
      >John

        Comment

        • flymo
          #3
          Re: access2007 combo stops filtering

          Hi Tom,
          Yes I get the same problem with the northwind and autoexpand is set to
          true.

          Thanks
          John


          On Mar 5, 9:03 am, Tom van Stiphout <no.spam.tom7.. .@cox.netwrote:
          On Wed, 5 Mar 2008 04:26:08 -0800 (PST), flymo <fly...@hotmail .com>
          wrote:
          >
          Can you reproduce this with the dropdown in the Northwind login form?
          Is AutoExpand set to True?
          >
          -Tom.
          >
          Hello All,
          I've bee trying out access 2007 and have a weird issue and would like
          to see if I'm issing something really basic.
          >
          I have a form based on a query, I create a combo to look for records
          on my form based on Org_ID. Wgen I create all is fine  - I type e,
          combo goes to e and starts filtering etc just like normal......I save
          the form, close the database and when I re-open the combo doesn't
          respond to any input - I can select a record and the form finds the
          record, but if I try to type in the combo nothing happens.
          >
          I have the db in a trusted folder, I have reverted to letting access
          create the combo with embedded macro (just trying to see if it's a
          code issue) - SP1 is installed....ma cros are allowed...
          Totally frustrated and would appreciate any guidance if anyone has
          resolved the same issue.
          >
          Thanks
          John

            Comment

            • flymo
              #4
              Re: access2007 combo stops filtering

              Hi Folks,
              I've created a dozen combos by wizard with this problem and it works
              ok.......but does not once the form is closed & reopened. THere is no
              other code or macro running...Reall y, really stumped and looking for
              suggestions.
              Thanks
              John





              On Mar 5, 10:13 am, flymo <fly...@hotmail .comwrote:
              Hi Tom,
              Yes I get the same problem with the northwind and autoexpand is set to
              true.
              >
              Thanks
              John
              >
              On Mar 5, 9:03 am, Tom van Stiphout <no.spam.tom7.. .@cox.netwrote:
              >
              On Wed, 5 Mar 2008 04:26:08 -0800 (PST), flymo <fly...@hotmail .com>
              wrote:
              >
              Can you reproduce this with the dropdown in the Northwind login form?
              Is AutoExpand set to True?
              >
              -Tom.
              >
              >Hello All,
              >I've bee trying out access 2007 and have a weird issue and would like
              >to see if I'm issing something really basic.
              >
              >I have a form based on a query, I create a combo to look for records
              >on my form based on Org_ID. Wgen I create all is fine  - I type e,
              >combo goes to e and starts filtering etc just like normal......I save
              >the form, close the database and when I re-open the combo doesn't
              >respond to any input - I can select a record and the form finds the
              >record, but if I try to type in the combo nothing happens.
              >
              >I have the db in a trusted folder, I have reverted to letting access
              >create the combo with embedded macro (just trying to see if it's a
              >code issue) - SP1 is installed....ma cros are allowed...
              >Totally frustrated and would appreciate any guidance if anyone has
              >resolved the same issue.
              >
              >Thanks
              >John

                Comment

                Previous template Next
                Working...