New rows in Subform

S

Steven

OK.. Here's my situation. I have a subform on a parent form. When
the parent form is loaded, the subreport queries data from a table in
the DB. The parent form has a couple of text boxes for data entry. A
command button on the parent form inserts that data from the text boxes
into the database... The subreport is then supposed to requery and show
the previous information as well as the just inserted information.

I have read a lot of posts and have found that SubReport.Requery
only show changes to data. It does not show any new rows. No one seems
to have the answer in showing the new rows.

Someone in the world should have figured out a way to deal with
this. I can't be the only one that has this problem...

Please help!!!

Thanks in advance.
 
H

Harm Ozinga

try
********
Private Sub [your sub form name]_Activate()
Me.Refresh
End Sub
********
or
********
Private Sub [your sub form name]_Activate()
form("[your parent form]").Refresh
End Sub
********

i'm not sure it will work but i think it should work

Harm Ozinga
 
Top