Filter Critiria Storage

[gg80]

I am having problem with access 2003. FormA opens and filters FormB (continuous form). The filter criteria could be a customeID, BoatName, or ModelID.



From FormB, the user can open FormC.

In A2003, I found that I had to close FormB before opening formC. If I didn't, some of the actions of formC overloaded A2003 and gave me the "Cannot open another database etc." message. Now, when I reopen FormB from FormC, the original filter has disappeared and the user sees a very long useless list of items.

In A2007, the filter stays with FormB, even after it is closed and opened.

I tried to store a filter expression in an unbound control in formC for use on reopening formB, but can't seem to find how to make it work or find anything on google that helps. Any help much appreciated.

[June7]

What is the code that sets the unbound textbox? Another option is global variable. Beware, global variables are a headache in debugging.

What is the code to reopen FormB?

[gg80]

Weird, but in a way, yoo solved it. I was setting up a sample to send you when I inadverently did the right thing. I had thought that the stored filter statement in the unbound control needed the same quotation marks required in the VBA statement. Apparently, xyz=1256, without quotation marks, is all that is needed.

Thanks much for the quick response and sorry to have bothered you.