Delete record

[Kirana123]

Hello

I tried to delete record from ms access I get error see in photo please help me how to solve this problem

[CJ_London]

You need a .form after your subform name and before the name of the control

[Kirana123]

Dear CJ,

I just change from Forms!frmNav.NavigationSubform!frmStdList.Requery in to Forms!frmNav.NavigationSubform.Form.frmStdList.For m.Requery

Still not get error !

[CJ_London]

Try
Forms!frmNav.NavigationSubform.Form.frmStdList.Req uery

[Micron]

Please do not post pics of code but copy/paste within code tags.
The form you want to requery is not on your nav form? I would suggest that you try forms!frmStdListmain.requery but for some reason that doesn't seem to refresh the records. Will have to look and see why.

EDIT - don't see why you're using a nav form at all. Simpler to make your own form and use it as a switchboard.

[Micron]

Yikes. The form you want to requery is a subform on a form that you're basically using as a container and nothing else. So
forms!frmStdListmain.frmStdList.form.requery

You're making things more complicated than necessary with that design.

[Kirana123]

Dear Micron

I Try is working i don't have error anymore

forms!frmStdListmain.requery

DoCmd.Close acForm, "frmStdListmain"
DoCmd.OpenForm "frmStdListmain"

[Micron]

Yikes. The form you want to requery is a subform on a form that you're basically using as a container and nothing else. So
forms!frmStdListmain.frmStdList.form.requery

No need to close the "main" form - just change the code to refer to the correct form.
You're making things more complicated than necessary with that design.

[Kirana123]

Yikes. The form you want to requery is a subform on a form that you're basically using as a container and nothing else. So
forms!frmStdListmain.frmStdList.form.requery

No need to close the "main" form - just change the code to refer to the correct form.
You're making things more complicated than necessary with that design.

Dear Micron,

Thank you for your help

Is working goed

Well Done !