I didnt understand the previous post but I figured it was just over my head....

I actually figured out the CP problem with a grueling process...but it works! (there HAS to be an easier way to do so though!) I do have another question while we're at it though, on the same form there are currently 5 records. I have it set so that it does not allow deletions, edits, or additions. (this is because I dont want to user to try to do so here) When the user selects the "Add New Program" button it changes the record source to a temp. table. The first few lines of the code is...

Private Sub saveprog_Click()
On Error GoTo Err_saveprog_Click

Form.AllowAdditions = True

Dim CPnum, CP, checkzeros As String


....

And even though the first thing I am telling it to do is to allow additions, it gets an error when you try to do so. Any ideaS?