Destined:

It is still unsuccessful!!! When I first run the form, it appears to show the accurate first record in the table, but when I attempt to change the data in 3 of the fields and then move to the next record, NOTHING happens!

I know that I am still learning, but I am curious, within the code of the cmdNextRec:

VB Code:
  1. If Not UpdateDBInformation Then Exit Sub

  2.  
  3. rs.MoveNext

  4. currIndex = currIndex +1

  5.  
  6. FillInformation

  7. AdjustEnableButtons
But how does the rs.MoveNext function know to use the appropriate recordset???

Because the query is opened within the form load...and the cmdNextRec (from what I can see) is only referring to the variable rs which is declared as a Recordset....could this be why it is not moving?

The other thing is that when I add a name to the Sales Rep field while in run mode, and then Quit, it is not updating the underlying table....

I will be working on this problem all day today, so if there is anything that comes to mind, please do not hesitate to let me know

THANK YOU!