Error when doing filter on form

[Guest]

Hello All
I have an issue I am trying to resolve and I need some help.

I have a database that I just created in access and pulled in data from an
old Approach database.

When I try to do a filter on Form it gives me an error and closes out. I
sent the error report to Microsoft and they said to intall the updates. I did
that and restarted and still I have the issue of not being able to filter on
the form.
I have other forms in this database and I can do it on them, but not on the
main form.

Does anyone have any ideas?

 

[Douglas J. Steele]

It could be some slight corruption in the file.

Try creating a new database and importing everything from the existing
database into the new one.

 

[Guest]

I tried that and it still is giving me the problem.
Anything else?

 

[strive4peace]

Hi Becky,

Is the main form bound?

Are you filtering on a field in the RecordSource or a calculated field?

how are you using the filter? Are you running code or doing it
manually? If you are running code, can you post it?

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Guest]

The form is based on a query.
There is no filter in the record source. There are calculations in the
query but none that filter data.

I am trying to use the filter by clicking on the filter by form icon in the
standard toolbar.
I am not running code to filter any data for this form as it needs to show
all data.

 

[Guest]

I also just tried to do the filter by form on the query itself and that is
OK. It lets me do that.
Just an FYI

 

[Guest]

I just emptied the table and tried to click the filter by form and it gave me
the same error. So it must not be the data but something in the form. I
just can't figure out what it might be.
I have sub forms but I have other forms with subforms and that filter works.

 

[strive4peace]

Hi Becky,

try right-clicking on the control you want to filter by -- if you have a
specific value, you can fill it out ... or filter by selection -- these
are the 2 choices I use most.

Perhaps you can't edit your form? I am not sure why the toolbar buttons
wouldn't be enabled... does the method I gave you above work? Or is it
not available either?

Warm Regards,
Crystal

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Guest]

Just an update on this issue you were trying to assist me on.
I created a new form and copied all the fields to the new form and still had
the same error. Today I started removing a few fields one at a time and
found that the a check box is causing the issue. If I remove the check box
it is ok. Why would that be? Any ideas?

Thanks for your help.

Becky

 

[Guest]

I found that it was not the check box itself but that I had a single check
box in an option group. I removed the option group and left the check box
and all is fine.

Thanks for all your ideas and helping me try to solve this issue.

Becky

 

[strive4peace]

you're welcome, Becky happy to help

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*