"No Current Record" Error message

[ElizabethB]

I have created a form based on a single table. The table has three fields (detail name, subject, yes/no) and the form uses only the Detail Name and Subject fields. The Detail Name is a text box and the Subject name is a list box with subject names built in for me to select from.

I have been quite happily putting in data but every so often, completely at random, when I enter a Detail Name and select a Subject the database returns an error message "No Current Record". I cannot work out why. There does not appear to be any common feature to the records it does this on.

Also, if I change what I have typed in any way the database will accept the changed record. One example of how this works is that if I type "Flood Defence" in the Detail Name box and select "Water" from the Subject list box it will come back "No Current Record". However, if I change the entry in the Detail Name box to "complete rubbish" and select "Water" it will accept it. Similarly, I can continue to enter data into further records.

I have not written any code in creating the form at all. The problem also applies if I try to enter the data directly into the table. The table is part of a relational database but I would have thought that if it was a relationship problem it would happen to all records or, at least, in a regular pattern.

Any help would be very much appreciated.

Elizabeth

 

[RpbertS]

Did you notice if your entering duplicate information? say you put flood defence and then picked water before? it may not allow you to do that,

you might also want to double check your tables and make sure you have the fields set to accept duplicates(if thats okay).

hth

 

[ElizabethB]

It is not a case of duplicate records. If I type in a duplicate record by mistake it comes up with a different error message telling me that it is a duplicate and needs to be changed.

EB