Access 2016 Error 424 (1 Viewer)

[pkraja]

I just installed Access 2016 32 bit and ran into this issue of not being to send data to a new record in form. Error '424' Object Required. Does anyone have a suggestion as to how I get around this. I cannot add Microsoft DAO 3.6 Object Library as the name conflicts with an existing library - presumably Microsoft Office 16.0 Access database engine Object Library. I unchecked the latter and checked the former but still get the same error.

 

[GinaWhipp]

Hmm, please post what References you do have checked.

 

[pkraja]

It turns out that I needed to used the syntax Forms![Form_Name]![Field_Name] = "XXX" as opposed to [Form_Name]![Field_Name] = "XXX" . Gotta love the Microsoft error messages.

 

[GinaWhipp]

And based on the message I thought it was a Reference problem... go figure!