filter form stopped working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have this strange problem:

I created a form based on a query of (SQL Server) using an .ADP file.

It works great for adding, editing and deleting records.

The problem starts when I try to open an existing record using the "Where" condition on the "docmd.OpenForm " command.

It works OK for a few days, and then won't work again. it opens an empty form (I see all controls with no values)

The most strange thing is when I'm creating a new form and just copy all controls to the new form (and the code module also) with no changes - the new form works like it should.

but then again - for a few days only.

This situation is very fraustrating and I cannot implement this simple form.

I even tried decompiling the file - didn't work.

Any great ideas ?

Daniel
 
I hope this would help:

After the form has become "un-filtrable" even a normal open (without filtering or restrictions of any kind) - the form can be used to insert new records only, it even fails to show existing records.
Click to expand...

You really should reply to your original posting. That way people have
an idea of what you are talking about.
 
Finally,

I have another button that opens the form for addition of a new record, this sets the DataMode property to True.

It apears that this property setting is saved and that's why I couldn't open any other records...
Click to expand...
You really should reply to your original posting. That way people have
an idea of what you are talking about.
 
Back
Top