issue with subform

[drrocket5292]

I have a subform that has three controls bound to a table. Theres a command button below the subform that opens a new form when clicked. That new form lets you enter information into it and has an insert query that adds it to the underlying table then closes itself. When it closes itself I would like the subform to update itself on the screen with the new information that was just inserted into the underlying table. Ive tried refreshing and requerying but neither will update the subform. The only way I can get the new information to be displayed is by closing the main form and reopening it. I tried the following simple code and it doesnt work:

dim frm as new form_authsigner
frm.refresh

ive also tried frm.requery. Would someone mind telling me what I am doing wrong? Thanks.

 

[Remou]

Have you tried (in an update event on the popup):
[tt]Forms![Main Form Name].[Subform Control Name].Requery[/tt]
Or, on the form itself:
[tt]Me.[Subform Control Name].Requery[/tt]