Server Filter property saved with the form

O

Ovidiu

Hi.

I developed an ADP project connected to a SQL2K as backend.
There I have Continuous forms (as lists) and OnDblClick it has to open the
details form for that specific object (Single form).
I use: DoCmd.OpenForm strDocName, acNormal, , strLinkCriteria
strLinkCriteria is in fact a WHERE clause.

I also have on lists a button "New record". This one open an
ADODB.Recordset, adds the new record, then store in a variable the Record_ID,
close the recordset and create the strLinkCriteria as above, and execute the
DoCmd... as above.

Some users complain that when they create a new record, next time they try
to open a record by DblClick on the list, they all the time receive the same
record (the last record they added as new).

In the OnClose event of the Single form I've added Me.ServerFilter="".
But it seems not working. Each time I face this, I found there is a Server
Filter property saved with the form (strLinkCriteria is saved).
I've asked users: "Have you used the save button on the buttons bar? - No."
I couldn't figure out when the ServerFilter porperty is saved with the form.

Any idea?
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top