Split Form does not show data in table

[jsbotts73]

I have made a form and put the Default View to split form. It was working just fine until today when suddenly the datasheet view showed an empty table. I have checked the table itself and it contains the expected data. The record source of the form is the table tblExpenses. In an effort to correct the problem I wrote my own Select statement as well as using the Query Builder and still get the same result. Any suggestions would be appreciated.

 

[jsbotts73]

Problem is solved. I was given "Similar Threads" when I posted this thread and got the answer. I had the data entry set to yes, and changing to no corrected the problem. Sorry for this post. Being new to Access Forum, perhaps I do not know how to search the prior threads. I entered a search and got back many hundreds of prior threads. I looked at many but could not find one that addressed this problem. So I will consider this tread as solved.

 

[missinglinq]

Commonsense would dictate that the Data Entry Property, set to Yes, would simply mean that you could...enter data! But, despite it's name, Data Entry Property, set to Yes...means that you can only enter new data...you cannot view previously entered data!

Just one of Access' many quirks!

Welcome to AW...and the crazy world of Access!

Linq ;0)>

 

[jsbotts73]

Thanks missinglinq for the explanation of the confusing property Data Entry.