Runtime Error 424 Object Required

[Maltheo2005]

Hi, I'm new with MS Access stuff and a newbie in this forum. But I need help with my form that works but always come up with an error "424 Object Required".

I created a pop up data entry form and when the SAVE button is pressed, it inputs the data into a table.
Here's my vba code and i don't get it why the dialog shows up even though it works fine.

Private Sub ButtonSaveAndExit_Click()


    CurrentDb.Execute "INSERT INTO Table_INV_2013(recDOE, recRegion,recMC,recType,recNum,recComp)" & _
        " VALUES('" & Me.Auto_Date & "','" & Me.NPSRegion & "','" & Me.NPSMain & "','" & Me.NPSType & "','" & Me.NPSNumber & "','" & _
        Me.TxtComplainant & "')"
        
       
    ButtonCancel_Click
    Records_2013.Form.Requery
    


End Sub

I'm not familiar with vba but I figured out how to construct its structure from the net. Hope someone help me resolve this problem. Thank you.

[pbaldy]

If you hit debug on the error, what line is highlighted?

[Maltheo2005]

If you hit debug on the error, what line is highlighted?

when i hit debug it highlights "Record_2013.Form.Requery"

[pbaldy]

I assume that's a form? See if using the appropriate syntax from here helps:

Forms Refer to Form and Subform properties and controls

[Maltheo2005]

I assume that's a form? See if using the appropriate syntax from here helps:

Forms Refer to Form and Subform properties and controls

Yes it's a form, I removed that line and it the error dialog box didn't show up. I now ask what's the purpose of that command? I just watched its tutorial from youtube and i have no idea what it is for.

Thanks for the link, I'll check that later.

[pbaldy]

It's your code, not mine, but I'd assume it's requerying the form to reflect the insert.

[Maltheo2005]

It's your code, not mine, but I'd assume it's requerying the form to reflect the insert.

I still have no idea abt that. But thank you anyways. The problem is resolved for the meantime.. will get back with tons of questions soon.

[pbaldy]

No problem, and welcome to the site by the way!

[Missinglinq]

...The problem is resolved for the meantime...

Forum etiquette dictates that when you resolve the problem, on your own, you post the resolution! In that way others finding this thread, while researching a similar problem, can benefit from your answer.

Linq ;0)>

[pbaldy]

I believe that's already been done:

I removed that line and it the error dialog box didn't show up.