Run Time Error '30014'

[TBernard]

I posted earlier about this error, but have found more
confusing pieces to this error message.

I have a continous form, in which I want to get the ID for
that record as soon as a message box is choosen from. I
posted the same question on Friday and Vadim Rapp did a
wonderful job answering the question for me.

But strangely no matter what I try, when I choose a
certain combinaton from the drop down boxes I get this
error:

Runtime error '30014':

The data was added to the database but the data won't be
displayed in the form because it doesn't satisfy the
criteria in the underlying record source.

It is very odd, the subform record remains blank, but once
I scroll one record forward or backwards the data
displays. I look in the tables and the data is saved
correctly and relates to the other tables correctly. The
subform itself has only one table as a record source. I
am not sure what can be causing this error, but it
actually saves the data correctly. More of a nuesance for
the users. The error also only occurs when certain
combinatoins of the drop down boxes are choosen from, most
choices in the drop down boxes do not give this error.

If anyone has run into this error before let me know. Any
help would be greatly appreciated.

TBernard

 

[Karen Vaudreuil]

Hi,

I had this problem a couple of times and if I remember well, creating a
view, instead of putting the table or an adhoc query as the recordsource
solved the problem.

Try this and you'll see.

Karen

 

[ChelleV]

Your form is built on certain conditions. When you chose
from the drop down box, it is making that record NOT fit
the original conditions for the form. Therefore, it is
changing the record correctly, but because of the new
conditions or the record, it is not able to be displayed
in that form.

I have had this error many times, and it is frustrating,
you may want to change the conditions of the form to be
broader and accept more conditions.

Hopefully this helps.
-ChelleV