In your post you say you are having trouble..... what are you having trouble with?

As Raymond said: Please be more specific. See Rule #2.

Your as written, with the table data you provided will likely ALWAYS find and AttendanceID having a PracticeDayofWeekID that is greater than zero because you're not specifying any other criteria so, for example, it will go to your table, find AttendanceID # 101 with a PracticeDayofWeekID of 1. The value 101 will be assigned to ID which should set off your "Are You Sure?"

At that point, is "Are You Sure?" firing? If not, is there any error and if so what is it?

If it is firing and no error, does it exit if you press "No" or "Cancel". And again, if an error, what error. If that part works, great.

If it is firing and no error, does it run your query if you choose "Yes". Does an error pop then or does it exit silently?

We need details of what is happening when to be able to help you.

it fires just fine it just does it all the time.  I am trying to look at the pracitceweedayid for that.  When the attendance goes to a new record that id number is not in the attendance table.  I just can't figure out how to look at that value.

So if you're clicking the button on your Attendance form and that form has PracticeDayofWeekID on it that is being passed to AddStudents_click, then your DLookup should probably be something like:

ID = Nz(DLookup("AttendanceID","TBLAttendance", "PracticeDayofWeekID=" & PracticeDayofWeekID),0)

This way, it will look up the Attendance records for that specific Practiceid and set the ID to whatever it should be if there are already records. If it doesn't find any matching records, ID will be zero and fire the query without the "Are You Sure?".

Cool, I will try that.  Thanks again for all your help.