Form not showing entered data

[ashu.doc]

Hello friends



I am facing a very strange problem in my application. It is a surgery logbook application. Earlier I was using an online data entry website for entering my operations, then I made one application on access, so I painstaikingly transfered all the data from website to my application, now, what has been happening is when I am entering a new set of data through my forms, it is entering correctly into all tables and also showing in final reports, but in the form itself when I am clicking "last record" it is only showing the last record which I had copy pasted from the website and when I am clicking the "previous records" it is showing the records which I copy pasted into the tables earlier, and NOT the last record which I am entering myself?

Thanks
Ash

[June7]

Would have to analyse the db. If you want to provide, follow instructions at bottom of my post.

[Missinglinq]

...when I am clicking "last record" it is only showing the last record...

...when I am clicking the "previous records" it is showing the records which I copy pasted into the tables earlier...

I've been reading this for two days, now, and it still says when you hit the 'last record' button, it shows the last Record, and when you hit the 'previous record' button it shows the previously entered Records!

So what is the question/problem?

The only thing I can suggest, and since I'm not sure what you're asking, I'm not sure it's the answer, but go to Properties - Data and see if the Data Entry Property is set to 'Yes.' IF it is, set it to 'No.' Despite its name, it doesn't have to be set to 'Yes' in order to enter Records! Set to 'Yes,' this property means that you can only enter New Records, you cannot view Records entered in a previous session.

Linq ;0)>

[ashu.doc]

I've been reading this for two days, now, and it still says when you hit the 'last record' button, it shows the last Record, and when you hit the 'previous record' button it shows the previously entered Records!

So what is the question/problem?

The only thing I can suggest, and since I'm not sure what you're asking, I'm not sure it's the answer, but go to Properties - Data and see if the Data Entry Property is set to 'Yes.' IF it is, set it to 'No.' Despite its name, it doesn't have to be set to 'Yes' in order to enter Records! Set to 'Yes,' this property means that you can only enter New Records, you cannot view Records entered in a previous session.

Linq ;0)>

What I am saying is, I had copy pasted some data into this application for example 100 cases. So when I am hitting last record it is showing the 100th record, that is fine, but now when I am manually entering the 101st case, and then hitting the last record it is only showing 100th record not the 101st record, although the records are still entering correctly in the tables and also showing in the reports as well, but NOT in the form??

[ashu.doc]

Would have to analyse the db. If you want to provide, follow instructions at bottom of my post.

Surgi-log 1.0.zip

please see the attachment

[Missinglinq]

The position of the Record in the Table is going to be determined by when the Record was entered; Tables do nothing to change this, so the last Record entered will appear last in the Table, the behavior you're seeing. Reports will reflect this same order, unless you do something, within the Report, to change the order.

Forms, on the other hand, generally have their Records presented in a sorted manner, the sort order depending on the needs of the user. Are the Records in the Subform being sorted?

Linq ;0)>

[June7]

Linq, records will display in table in order entered unless there is indexing or table is saved with a defined sort order, but generally, yes, the order entered is the order displayed.

ashu, I tried to open your zip but 7-Zip fails, think the zip is corrupted.

[ashu.doc]

Hi guys
I dont know what happened I was testing the application again by entering the data and an error message came and application shut down leaving a backup file and another original file of application, the original file became smaller in size (from 21 mb to 6 mb) but the backup file remained 21 mb. Anyways when I opened the original file 6mb it had everything same all the data which I fed originally (21 mb) and it is showing all the records in the form now, that means my problem solved itself...somehow. But the backup file is not showing the last entered data in the form. Very strange, just curious, what happened.

[June7]

The app crashed while you were entering a record? I guess the record did not get committed to table. App must have run Compact & Repair automatically so the original file size was reduced. Is this a split design or all-in-one db? Should run C&R periodically, especially after design edits.