Form counter starts over when closed and reopened

[BluSuedeNicNac]

I am making a very simple database in which a single split form updates a few different tables. A lab tech will enter sample details for one table, test result details for another, and sample treatment details for a third. The tables are all linked by unique sample IDs.

When the tech opens Access, the entry form loads but the counter starts over at "1 of 1". They cannot navigate to existing records in the database. The counter continues to count up as they enter data, and they can go back and select records created during that session to edit or review at any time. Once they close the form or close Access, it all starts over.

Note that the records themselves still exist. One can get to the information by loading up the appropriate tables, but the form will not permit one to navigate to records created before the session started to edit them or just view them in the form. How can I make the form load up existing records when it is opened and continue from where the previous session left off?

[Rabbit]

The form probably has the Data Entry property set to yes. This puts the form in new data entry mode only. Meaning you can only add new records and modify records added since the form was opened.

[BluSuedeNicNac]

Nope, already checked that. Data Entry is set to "no"

[ADezii]

Kindy Post the Record Source for the Form.

[BluSuedeNicNac]

SELECT [AA - Sample ID].ID
   , [AA - Sample ID].Bowl
   , [BA - Sand Mass].Mass
   , [CA - PRC Novalac].Mass
   , [CA - PRC Novalac].Time
   , [CB - PRC Hexa].Mass
   , [CB - PRC Hexa].Time
   , [CC - PRC Quench].Mass
   , [CC - PRC Quench].Time
   , [DA - CRC Novalac].Mass
   , [DA - CRC Novalac].Time
   , [DB - CRC Resol].Mass
   , [DB - CRC Resol].Time
   , [DC - CRC Hexa].Mass
   , [DC - CRC Hexa].Time
   , [DD - CRC Quench].Mass
   , [DD - CRC Quench].Time
   , [EA - Siloxane].Mass
   , [EA - Siloxane].Time
   , [EB - Chembetaine].Mass
   , [EB - Chembetaine].Time
   , [EC - Drop Quench].Mass
   , [EC - Drop Quench].Time
FROM (((((((((([AA - Sample ID] 
   INNER JOIN [BA - Sand Mass] 
      ON [AA - Sample ID].ID = [BA - Sand Mass].ID) 
   INNER JOIN [CA - PRC Novalac] 
      ON [AA - Sample ID].ID = [CA - PRC Novalac].ID) 
   INNER JOIN [CB - PRC Hexa] 
      ON [AA - Sample ID].ID = [CB - PRC Hexa].ID) 
   INNER JOIN [CC - PRC Quench] 
      ON [AA - Sample ID].ID = [CC - PRC Quench].ID) 
   INNER JOIN [DA - CRC Novalac] 
      ON [AA - Sample ID].ID = [DA - CRC Novalac].ID) 
   INNER JOIN [DB - CRC Resol] 
      ON [AA - Sample ID].ID = [DB - CRC Resol].ID) 
   INNER JOIN [DC - CRC Hexa] 
      ON [AA - Sample ID].ID = [DC - CRC Hexa].ID) 
   INNER JOIN [DD - CRC Quench] 
      ON [AA - Sample ID].ID = [DD - CRC Quench].ID) 
   INNER JOIN [EA - Siloxane] 
      ON [AA - Sample ID].ID = [EA - Siloxane].ID) 
   INNER JOIN [EB - Chembetaine] 
      ON [AA - Sample ID].ID = [EB - Chembetaine].ID) 
   INNER JOIN [EC - Drop Quench] 
      ON [AA - Sample ID].ID = [EC - Drop Quench].ID
ORDER BY [AA - Sample ID].ID;

[z{moderators comment: Please consider renaming the fields using the "-" sign.
Access 2007 reserved words and symbols
AllenBrowne- Problem names and reserved words in Access}]