Hello
I tried to delete record from ms access I get error see in photo please help me how to solve this problem
Hello
I tried to delete record from ms access I get error see in photo please help me how to solve this problem
You need a .form after your subform name and before the name of the control
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 !
Try
Forms!frmNav.NavigationSubform.Form.frmStdList.Req uery
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.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
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.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Dear Micron
I Try is working i don't have error anymore
Code:forms!frmStdListmain.requery DoCmd.Close acForm, "frmStdListmain" DoCmd.OpenForm "frmStdListmain"
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.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Dear 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.
Thank you for your help
Is working goed
Well Done !