On a form I have a command button that I'm writing code for. What I need for this button to due is to open one table and compare it to records in a second table. The problem I'm having and it's stumping me b/c it seems like a bug is that Access will recognize some of the fields in both tables but it won't recognize the others. Even if just try to write code for just one of the tables it will recognize the first field in my table but none of the others??? Any ideas???