Referencing Navigation Form SubForm

[speakers_86]

Your doing this:

Forms!frmHome!frmDataSource.Form!frmDay1.Requery

You need to be doing this:

Forms!frmHome!frmDataSource.Form!frmDay1.Form.Requery

In the first version, you are attempting to require a subform CONTROL. This is the object that houses the subform, and it cannot be requeried.

Also, I do not believe you need to set Dirty=False in the form close event. I do believe insert and update have already fired by this point.

 

[JamesJoey]

I copie dand pasted your example and got the same errors.

It's looking for a field.

can't find field frmDay1
can't find field frmWeeklyAgenda

I'm considering going back to the navigation pane.

 

[speakers_86]

I showed you how to do it in the sample I uploaded. If you can post an mdb I will help.

 

[JamesJoey]

I am using your example.

Also, I tried creating an mdb but they don't support Navigation Forms.

 

[speakers_86]

I'm not sure how else to help. This attachment has object names you are using and works fine.

 

[JamesJoey]

I'll work on it some more myself.

In the mean time I'll use command buttons to open forms.

Thanks much for your time and effort,
James

 

[arnelgp]

please take a look at the code-behind frmDay1 to frmDay7, frmweekview and frm RemidersEdit.

we only need to requery the subform in view, when you click the button to change view, access automatically do the requery for you before displaying the corresponding subform.
https://www.dropbox.com/s/3chnrb89eba0vx9/Agenda.accdb?dl=0https://www.dropbox.com/s/3chnrb89eba0vx9/Agenda.accdb?dl=0