By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,687 Members | 2,065 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,687 IT Pros & Developers. It's quick & easy.

New rows in Subform

P: n/a
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.

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Steven wrote:
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.

If I need to requery a subform, the syntax would be
Forms!MainFormName!SubFormName.Form.Requery
Nov 13 '05 #2

P: n/a
Tried this and it only shows changes to rows that are already there. It
does not show any new rows.

Nov 13 '05 #3

P: n/a
Steven wrote:
Tried this and it only shows changes to rows that are already there. It
does not show any new rows.

That's odd. Requery will execute the SQL string contained in the
Recordsource. The only thing I can think of is that you have a filter
that the new records don't match. You might want to do something like
Forms!MainForm!SubFormm.Form.Filter = ""
Forms!MainForm!SubFormm.Form.FilterOn = False
Forms!MainForm!SubFormm.Form.Requery
Hmmm...
First do a
Msg Forms!MainForm!SubFormm.Form.Filter
to see what the current filter is. You may need to set the filter to
the link fields only.

That's the only thing I can think of that would not show all the records
associated with the main record.

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.