Thanks for your help. Using the debugger it helped me isolate the issue
as the table being wrapped in a sub form. Soon as I removed it and
adjusted the code everything worked perfect.Just wish I could keep that
sub form as the form's hierarchy will be pretty confusing without it. If
anyone knows a workaround let me know please.Thanks again.