Rookie Access question...

[Mike Simanyi]

Sorry to post such a basic question - my experience is with Visual
FoxPro and Access is quite a different animal!

When I open the form that accesses our corporate data, I believe it
tries to refresh the data in the same state it was last accessed. The
problem with that is I was trying to filter for a business name that
included an apostrophe, and the code for that causes an error. At this
point, I'm unable to open the form and use our database.

I searched the registry for any reference that includes the last search
data and came up blank. Does anyone know where this is stored so I can
purge it and begin using my corporate database again?

Thanks in advance.

Mike

 

[Mike Simanyi]

Nix that... I found the location of the filter (Form Properties, Data
tab, Filter) and I've cleared it.

Mike