I found a solution to my first question. Missing data was caused by the order of my IF statements inside the code. I changed the order as I was coding and that messed around with the data that was displayed in the grid. Put the statements to a logic order and everything works just the way I wanted. Hours of trial and error and recoding....and all because of this little mistake.

Thank you all for your help. Thread solved!