By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,376 Members | 3,024 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,376 IT Pros & Developers. It's quick & easy.

access2007 combo stops filtering

P: n/a
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
Mar 5 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Wed, 5 Mar 2008 04:26:08 -0800 (PST), flymo <fl****@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....macros are allowed...
Totally frustrated and would appreciate any guidance if anyone has
resolved the same issue.

Thanks
John
Mar 5 '08 #2

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

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

This discussion thread is closed

Replies have been disabled for this discussion.