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

Form fields to Report

P: n/a
I have been over the forums here, and I'm not sure if I have a unique
situation, or I'm doing it wrong.

I have a form with 7 listboxes. Each one is unbound, and the results
chosen by the user are fed to the report.

I also have checkboxes that are bound to a query.

I am only able to display the data in the listboxes OR the checkboxes
on the report, not both.

The other issue is that I want to have the form bound to a specific
client. The information shown on the form is for that client only.
That information gets updated, and sent into the report to print out.

I would like the report to show that it is reading the client's
information from the form from the listboxes AND the checkboxes when
it is in report print preview.

Any help you could give me would be appreciated. I've already been
through (and was helped by) the link http://allenbrowne.com/ser-50.html.

Nov 1 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Nov 1, 2:52 pm, mbolokof...@seniorneighbors.org wrote:
I have been over the forums here, and I'm not sure if I have a unique
situation, or I'm doing it wrong.

I have a form with 7 listboxes. Each one is unbound, and the results
chosen by the user are fed to the report.

I also have checkboxes that are bound to a query.

I am only able to display the data in the listboxes OR the checkboxes
on the report, not both.

The other issue is that I want to have the form bound to a specific
client. The information shown on the form is for that client only.
That information gets updated, and sent into the report to print out.

I would like the report to show that it is reading the client's
information from the form from the listboxes AND the checkboxes when
it is in report print preview.

Any help you could give me would be appreciated. I've already been
through (and was helped by) the linkhttp://allenbrowne.com/ser-50.html.
What you need is one function that is called from every control in
each controls' AfterUpdate event. This function should create the
query for the report based on the values in every control.

Nov 1 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.