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

Requery Subreport list-box control

P: n/a
Ed
Hello!

I have a report that includes a subreport. They are linked together by
a common ID field. The subreport contains 6 controls, 5 of them text
boxes with a control source and one of them is a list box based on a
query.

The text boxes that have a control source show the correct data for
multiple records of the subreport but the listbox is only queried once
and it does not change for other records.

All the queries and linked fields are correct. Is there a way to
requery the list box for every record in the subreport. Something like
OnCurrent() maybe.

Thank you!

Ed
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Ed
I solved this problem by requerying the listbox control in the OnPrint
method of the subreport.

report
subreport
onprint
listboxt.requery
I noticed that a lot of people had asked about this question but very
few had answers. The onprint() can be used just like the oncurrent()
for the form. It is a little bit misleading because the name lets one
think that it will be called right before the request is sent to the
printer, but that is not the case. It is called when the report is
generated to the screen.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.