Please show your code so we can see what is causing the error. It could be something as simple as a missing reference.

In the VB Editor go to Tools -- References and make this reference is checked.

Microsoft Office 16.0 Access Database Engine Object Library

Kevin that worked how I am running into a another problem

Is the field spelled correctly in the Table?

I found my misstate