Very strange problem of disappearing and reappearing data...

[bencombes]

Good morning, I am experiencing an extremely strange problem that I will try to explain here...

I have got a subform which goal is only to display a few fields from a database. Not any interaction is made from mother forms, it just displays data, and that's all. It is really simple, and has been created with a wizard.

One of the fields, that is named OrderPart, has got for values either True or False. Most of the times, I don't have any problem, but, only when all the OrderPart fields are set to false, nothing is displayed anymore on the form, like if everything were hidden.

And if I change only one of these values to true, all other rows reappear, including those with the OrderPart field set to false.

The query to get the data is: SELECT subparts.* FROM subparts WHERE (((subparts.repairno)=[forms]![subpart assignment]![reportno])); . Moreover, when I run it outside the form, it always displays all information.

I don't have any filter, my request selects all objects, and I don't have any code, so I absolutely don't understand how this may happen! So if somebody should have a little clue, it should be very nice, thank you very much !!!

 

[RV]

I'd say that indeed you've got some code somewhere.
Hence the jpg file isn't much use.
Post your database, zipped.

RV