Continuous Form Update

[Tukayoo]

I have a continuous form that is a sub form. The record source for the sub form is a query. When a field on the main form is updated the query is updated to reflect the correct data, however, the issue I am running into is that the sub form's data does not update until I click on the refresh all button from the ribbon. Does anyone know how to get the form to update either by built in functions or by using VBA which would be preferable? The me.Refresh does not work. I have done both the following and it does not seem to update.



Private Sub Form_Activate()

Me.Refresh

End Sub

I have also tried this

Private Sub Form_Load()

Me.Refresh

End Sub


The sub from is in a tab and so I have also tried

Private Sub TabName_Click()

DoCmd.Requery

End Sub

Also this

Private Sub TabName_Click()

Me.SubFormName.Requery

End Sub

I am new to VBA so any help would be greatly appreciated.

Thanks

[ranman256]

me.requery ,updates ME, the MAIN form

me.MySubform.form.requery, will update the subform

(and its already updated, the code just refreshes the data)

[Tukayoo]

me.requery ,updates ME, the MAIN form

me.MySubform.form.requery, will update the subform

(and its already updated, the code just refreshes the data)

So I think I had tried that, but the data in the continuous form does not update to reflect what is in the query. how do I get the form to reflect what is in the query?

Thanks

[June7]

Main form and subform bound to same data? You are trying to emulate Split form?

The edit in main form must first be committed to table. Record is committed when: 1) close table/query/form; or 2) move to another record; or 3) run code to save.

You don't show any code that commits record on main form. Did you try ranman's suggestion? The trick is figuring out what event to put code into.

[GinaWhipp]

Try putting the Requery in the On_Current event as the On-Click event only fires when you initially click the Tab.