Hello mmcdonal,

Your points have been very insightful. I tried to run the first codes earlier on and got error codes. I realized that I was missing the form pointer as you and Old pendant mentioned and got it to work last night which I am proud to say mirrors yours ( before looking at your post,,, I must be learning something after all). A pesky error remained with the checkboxes but after seeing your post and your use of the variables it cleared it right up ( I will definitely keep that in mind from now on). Thanks a lot for the assist I truly do Appreciate it.

If I could touch on a few things you mentioned earlier. You said that errors may occur if you declare and run the Sql in one step in VB. What kind of errors are those in general terms?

You made a good observation on the data verification. I'm somewhat Green on the whole access VB scene. In the past I made programs by using a whole bunch of queries forms and not much else. Now I’m trying to get a little more experience by forcing myself to go SQL whenever possible.

It was always my intention to do the verification but I figured one battle at a time. I'm not sure if this should be a new post item or if you could help cover it here how do you handle data verification? Should it be a module of some sort or embedded in the form... or perhaps a combination of the two?

Just want to thank you again for the help, I read many posts without success but your approach was very clear and I feel I have a better grasp of the subject now. I'll need to polish it a bit but I can see the relative way things fit together now.

Luis