Filter Doesn't Work

[wonderwhy]

Hello,

I posed this question at the bottom of another posting but I haven't gotten a response. I will try it by itself.

I have a form with a button that opens a small form that is used for searching the form/subform records. The small form has a two combo boxes and two buttons. The user can use either combo box and choose the record they want to view(one lists the records by name and one by number) and click the respective button and the record opens in the main form/related subform. They can do as many searches as they need using either combo box/button. I have a button on the mainform that removes the filters and "shows all records".'

The problem is that this works on my computer but not on theirs. We are both using the same database which is saved to a network.

When the user tries to search on the small form they can search and find one record but every other subsequent search does nothing. I have had the user close the database and even shut down her computer and the same thing occurs. Yet, it works perfectly on mine.

Any suggestions why this might be happening?

Thank you for your help!

Julia

 

[legos]

they might have a module set wrong. check to make sure you are both using the correct doa or ado module. it is located under tools, references in your VB window

Durible Outer Casing to Prevent Fall-Apart

 

[wonderwhy]

Thank you very much for the suggestion. I'm leaving work now, but will check it tomorrow and let you know if that did the trick.

Thanks again,

Julia

 

[wonderwhy]

Bummer. I checked tools/references in VBA window. Her settings are the same as mine! I came back to my computer and tried the combo boxes and buttons and they work perfectly. Back to hers and they don't. I just don't understand - this is the same file!

Thank you for the suggestion, legos, does anyone else have an idea???

Julia