When I created the initial tables for my database, I (not thinking) named one of the fields DATE. While working in the form, I decided I wanted the current date to populate in one of the fields. After some head scratching, I realized that when I use the Date command in VBA, it was calling the DATE field I had in the table. I went and changed the field's name to COR_DATE, and did a find/replace to change any other locations it was listed.
Now when I type Date, it still reverts to DATE, and the code fails saying member not found. I see that DATE is still a member of the form in the object browser, is there a way to delete it as a member, or refresh the members list?
I'd appreciate any thoughts... am I missing something obvious?