Synchronize Two Related Subforms on a Main form

[moishy]

I followed the instructions for Synchronizing Two Related Subforms on a Main form at http://www.fmsinc.com/microsoftaccess/forms/synchronize/linkedsubforms.asp.

For some reason the hidden textbox doesn't get updated as I move from record to record, and therefore the whole-thing doesn't work.

The weird thing is that it used to work, and just recently stopped.

Any ideas?

 

[moishy]

Never mind, I sorted it out after some head banging.

The method outlined in the above link will only work if there is no code on the OnCurrent event of the main subform. If some code does exist you must manually requery the hidden textbox (i.e. add the following to the OnCurrent event in the main subform: Forms![YourFormName]![YourHiddenTextbox].Requery).

 

[manda]

hello i also followed the instructions above - my issue is that the second sub form only updates based on the first sub form if i click in it. i am a novice access user. do i need to refresh somehow??