Subform refresh problems - explained? (1 Viewer)

[MikeAngelastro]

Hi,

I had problems refreshing a subform after updating its underlying table using a popup form. I did a search within this forum and found nothing to shed light on my problem. I was doing already what was recommended, but it wasn't working. So I thought about it a little more and happended upon the idea that the subform was refreshing before the underlying table was updated. Because I was using a popup form to update the table, I had to put the refresh command in the close event of the popup form. That way the refresh command is executed after the underlying table is updated and not before.

So if you are having a problem refreshing a subform, consider that it may only be because the code is doing the refresh before the underlying data is updated.

Thanks,

Mike

 

[Rich]

Actually it should be Requery after first saving the record

 

[MikeAngelastro]

You can either refresh the parent form or requery the subform.