It's hard to understand what you're saying the issue is.

Can you add new records to the table directly?

Is the Form you're using based on a Query?  (You could have a problem with a relationship, or Primary Key not defined)

You could also open the Table in Design view and see if there are any validation requirements.

Could you post some screen shots so we can see what you're trying to do?

Also... do you have a BACKUP that works?

You could also try a Compact and Repair.

Make sure you're not exceeding the 2 GB Limit.

There is nothing in your code telling Access to move to a new record.

What Kevin in saying is correct... your code tells it to Order by the TuitionRenewalDate, then go to the first record.

Change:

"DoCmd.GoToRecord , , acFirst"
to
"DoCmd.GoToRecord , , acNewRec"

Not sure if this is what you're wanting it to do....

Raymond
Thanks Raymond - fair questions

Unless I am mistaken, the table that the form is set up to populate should populate with new records after every renewal update.  **  If this is not the case - there is my brain error #1 and maybe part of my issue. lol

- The records in the table seen in the 'before pic' are the same records in the after pic just with changed dates.
- The 6/16 memberships with a renewal date of 6/23 have been replaced by the 6/23 records with a renewal date of 6/30
- instead of being added to (make sense?)  

Yes I can still add to the table directly as well as the form

If I understand your question, no, the form is not based on a query.
- The form is an exact match to Richards design for Memberships (*using a copy of his continuous form)

There are no validation requirements in the table. Only default date values

Yes, I can post screen shots, please elaborate of what you would like :)

Raymond

No back up that works, I just built it

I compact and repair all the time :)

the database is only 39,936 KB (its a baby)

Kevin

Ok, I see what you are saying, I was wondering also but - Move to new record or create one?
I ask this way because it does move to the next, it just doesn't create the new - or is that what you are saying/meaning?

If it helps, there are no other customer order items, details etc.
this is a Very basic renewal - 1 charge (membership fee/tuition), due weekly

What do you want 'Command66' to do?

Are you trying to create new records for renewals?  Or change the dates of existing records?

I would not use While-Wend with a requery or refresh either... it's going to eventually get stuck in a loop.

To set this up properly... you should have more than 1 table:
Student Table
Tuition Table (needs the Student ID)

Then I would create a loop to run thru your Student Table and create an Tuition Renewal for each Student.  You might also want an "Active" field to keep track of active students.  This would work better using SQL too....

Recordsets
Access Developer 16

Kevin

Thank you Kevin!
I heard Richard say in the tutorial "this way works,  . . but the 'proper way' is with a record set"
I will work on it :)

Raymond

Raymond, my apologies, I do have all the other tables needed for this, I was trying not to give an over-abundance of info.
The Student Table (w/IsActive), Tuition Table, Payment Table etc all exist.

The desire is for new records to be created.
That said, your comment . . . "I would create a loop to run thru your Student Table and create an Tuition Renewal for each Student."  . . . shows me that I removed the part of where the tutorial "opened the CustomerF" but I did not replace it with the "Open the StudentT"  

I was trying to conquer the knowledge of the Loop aspect before tying to tackle anything further :)

Thank you! Let me fix the code

Thank you ! :)