I added this but I am still getting
the same issue....If I add  a record  and the current spreadsheet  has 5
rows of data  the first time I click  the button form  clears of data
because the record number changes to row  6. After I save  the data
the form shows the data I just save... If I then select the add
another record cmd button  again, the form clears the data I added to
row 6 from the form, but the rownumber (I use this to determine what
record (row) I am on) stays at row 6.

I think the issue  is centering around the lastrow variable I have...
this variable is used to determine the lastrow and as part of the cmd
button to add a new record, it executes "RowNumber.Text = FormatNumber
(LastRow, 0)". When I save the data I just input to the newly
displayed record, lastrow is still pointing to row 6... how do I get
it to now recognize the lastrow has changed?