Connecting Tech Pros Worldwide Forums | Help | Site Map

access2007 combo stops filtering

flymo
Guest
 
Posts: n/a
#1: Mar 5 '08
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....macros are allowed...
Totally frustrated and would appreciate any guidance if anyone has
resolved the same issue.

Thanks
John

Tom van Stiphout
Guest
 
Posts: n/a
#2: Mar 5 '08

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.

Quote:
>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....macros are allowed...
>Totally frustrated and would appreciate any guidance if anyone has
>resolved the same issue.
>
>Thanks
>John
flymo
Guest
 
Posts: n/a
#3: Mar 5 '08

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:
Quote:
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.
>
Quote:
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.
>
Quote:
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.
>
Quote:
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....macros are allowed...
Totally frustrated and would appreciate any guidance if anyone has
resolved the same issue.
>
Quote:
Thanks
John
flymo
Guest
 
Posts: n/a
#4: Mar 12 '08

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...Really, really stumped and looking for
suggestions.
Thanks
John





On Mar 5, 10:13*am, flymo <fly...@hotmail.comwrote:
Quote:
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:
>
Quote:
On Wed, 5 Mar 2008 04:26:08 -0800 (PST), flymo <fly...@hotmail.com>
wrote:
>
Quote:
Can you reproduce this with the dropdown in the Northwind login form?
Is AutoExpand set to True?
>
Quote:
-Tom.
>
Quote:
Quote:
>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.
>
Quote:
Quote:
>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.
>
Quote:
Quote:
>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....macros are allowed...
>Totally frustrated and would appreciate any guidance if anyone has
>resolved the same issue.
>
Quote:
Quote:
>Thanks
>John
Closed Thread