Have you seen [this question](http://stackoverflow.com/q/20661510/2144390)? I was opening the table in Design View and then trying to modify the macro and it wouldn't work that way. However, once I started opening the table in Datasheet View and then modifying the macro it worked fine.
– Gord ThompsonMar 08 '16 at 17:33
Hi Gord, many thanks for the reply.
I think I finally got the code to validate but the field within the table remains blank when I add a new record. Please refer to below screen captures I am about to attach. Thanks again for your time.
– Paul McQuadeMar 14 '16 at 12:34
Sorry, I don't see any option to upload screen captures. I'm wondering if the blank field problem is to do with how the field data type is declared, should this be Number or Text?
– Paul McQuadeMar 14 '16 at 12:39
I set the field to Text with 12 characters but still get a blank field when adding records. Also tried resetting the table with the Repair Tool but still the same result. I have added some links to screen captures above in my original post.
– Paul McQuadeMar 14 '16 at 13:11
1
Your final `SetField` action is inside the `Look up a record in` block. Move it down to have it outside that block (but still within the `If [IsInsert]` block).
– Gord ThompsonMar 14 '16 at 13:21