New Record not found when using the scroll feature

[Steven1968]

I have a database where we track each employees position assignments each day and where they sat and for how many hours. To enter the information we open the "position" form which opens the form in add mode, the date is prefilled, enter the employees name which is linked to an employee table, then there are 24 fields where we enter a number (of hours) that person sat at a particular position (ie north zone, county fire, sick, etc) there is an action button to press that takes you to the next record. Once you are all done press the action button returning you to the main menu. Here is the kicker if I go back in to say add another employee that I mistakenly left out I cannot see any of the records I just entered, When I say I can't see them means I have opened the "Positions" form like I was entering a new record and using the record navigation arrows at the bottom of the form with the arrows I want to see record 400 or 399 and even though the record number is there what I just entered is not what I see. What I might see is an employee that was entered 8 hours ago? To further the problem it does not happen all of the time just sporadically? But if I go to the table and look at the datasheet view all of the records are there safe and sound?

I have tried many different things to figure this out but have come to my wits end. Is there a better method for entering this information? If so I would gladly make any modifications needed.



Thanks for anyone willing to offer advice.

[Steven1968]

I forgot to add that although the records are in the table the sort order might have something to do with it because like I said if I go into the table and sort by date lo and behold there they are but if you try to just go backwards using the record navigation arrows they are in a different order from when you put them in.

[orange]

What is the record source of your form? If itis a table, then any order is possible. Relational databases do not necessarily store data in any specific order. If you want your records in a particular order, then use a query on your table along these lines.

Select your field name1, your field name 2,.....from YourTableNameGoesHere
Order by RecordDate (whatever your date field is) Ascending

Note again: There is no guaranteed order to records in a table. Use an Order By select query to establish a desired order.

[Steven1968]

What is the record source of your form? If itis a table, then any order is possible. Relational databases do not necessarily store data in any specific order. If you want your records in a particular order, then use a query on your table along these lines.

Select your field name1, your field name 2,.....from YourTableNameGoesHere
Order by RecordDate (whatever your date field is) Ascending

Note again: There is no guaranteed order to records in a table. Use an Order By select query to establish a desired order.

Yes the record source is indeed a table, and thank you for the additional information I will give that a try to see if that works.

[Missinglinq]

...To enter the information we open the "position" form which opens the form in add mode...

AddMode is just like having Data Entry set to 'Yes;' you can only add New Records, you cannot view/edit existing Records, and the Records you entered during your last session are no longer 'new.'

Linq ;0)>

[Steven1968]

AddMode is just like having Data Entry set to 'Yes;' you can only add New Records, you cannot view/edit existing Records, and the Records you entered during your last session are no longer 'new.'

Linq ;0)>

Thank you to the first poster you jump started my thinking and I have solved the issue. I opened the forms properties and placed the following parameters in the order by field: [tblPosition].[Date], [tblPosition].[TimeModified] so now when the form loads the records are ordered first by date then by the time it was modified.

Thank you.