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

Trying to get info from form to a report

P: n/a
I have searched the boards but I have not found what I am looking for
yet.

I have a form with two combo boxes. When the user makes a selection
in both of the combo boxes the information will look through two
tables and return the appropriate matches. This will be very small
scale at the beginning but once I get everything working it will
include more tables and dozens of matches to be returned.

I would like the information to print to a report and not on the form.
I do not understand how to get the information into a report however.
I have seen some posts mentioning going through a query first but
again I do not understand how to do that also. The user will have
access to nothing but the form which will have a few command buttons
on it.

I am trying to teach myself Access so any help here would be greatly
appreciated. If you could reply with an example that would be even
better.

Thanks for the help.
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Design a report and place a text box on the report for each control that's
on your form. Now set the Control Source of each text box to a control on
your form like this(replace MyForm and MyControl with names of your form and
controls):

=[Forms]![MyForm]![MyControl]

Now select the info on your form and I assume you will place a command
button on your form to open the report. The form has to remain open for
this to work.
--
Reggie

www.smittysinet.com
----------
"Alex" <ab*****@verizon.net> wrote in message
news:7a*************************@posting.google.co m...
I have searched the boards but I have not found what I am looking for
yet.

I have a form with two combo boxes. When the user makes a selection
in both of the combo boxes the information will look through two
tables and return the appropriate matches. This will be very small
scale at the beginning but once I get everything working it will
include more tables and dozens of matches to be returned.

I would like the information to print to a report and not on the form.
I do not understand how to get the information into a report however.
I have seen some posts mentioning going through a query first but
again I do not understand how to do that also. The user will have
access to nothing but the form which will have a few command buttons
on it.

I am trying to teach myself Access so any help here would be greatly
appreciated. If you could reply with an example that would be even
better.

Thanks for the help.

Nov 12 '05 #2

P: n/a
Hi Alex,

Given that you're trying to learn Access you might add
microsoft.public.access.gettingstarted to your list of newsgroups.
Tablesdesign is another good one for getting going.

I'm not entirely clear about where and how the "appropriate matches" you
referenced below are being returned.

One way or another you'd want the query on which the REPORT is based to have
the same criteria. So, in the QBE grid for the relevant fields in the
query for the REPORT, have each criteria refer back to it's combobox on the
form (which must still be open). Since they're comboboxes, you'll be
getting the bound column value by default. You can explicitly choose a
different column if necessary: forms!MyForm!MyCbo.column(n)

HTH
--
-Larry-
--

"Alex" <ab*****@verizon.net> wrote in message
news:7a*************************@posting.google.co m...
I have searched the boards but I have not found what I am looking for
yet.

I have a form with two combo boxes. When the user makes a selection
in both of the combo boxes the information will look through two
tables and return the appropriate matches. This will be very small
scale at the beginning but once I get everything working it will
include more tables and dozens of matches to be returned.

I would like the information to print to a report and not on the form.
I do not understand how to get the information into a report however.
I have seen some posts mentioning going through a query first but
again I do not understand how to do that also. The user will have
access to nothing but the form which will have a few command buttons
on it.

I am trying to teach myself Access so any help here would be greatly
appreciated. If you could reply with an example that would be even
better.

Thanks for the help.

Nov 12 '05 #3

P: n/a
I would like to say thanks for the replies that I have recieved. I
believe I am good to go now. I have done a few quick tests with the
replies that I got and so far it looks great.

I'd like to thank Reggie for explaining the response the way that it
is (if some of the books that I have only did the same I wouldn't need
to post for help)

Alex
ab*****@verizon.net (Alex) wrote in message news:<7a*************************@posting.google.c om>...
I have searched the boards but I have not found what I am looking for
yet.

I have a form with two combo boxes. When the user makes a selection
in both of the combo boxes the information will look through two
tables and return the appropriate matches. This will be very small
scale at the beginning but once I get everything working it will
include more tables and dozens of matches to be returned.

I would like the information to print to a report and not on the form.
I do not understand how to get the information into a report however.
I have seen some posts mentioning going through a query first but
again I do not understand how to do that also. The user will have
access to nothing but the form which will have a few command buttons
on it.

I am trying to teach myself Access so any help here would be greatly
appreciated. If you could reply with an example that would be even
better.

Thanks for the help.

Nov 12 '05 #4

P: n/a
Alex, These news groups have helped me out many, many times. Anytime I can
help someone else in any way, it's my pleasure.

--
Reggie

www.smittysinet.com
----------
"Alex" <ab*****@verizon.net> wrote in message
news:7a*************************@posting.google.co m...
I would like to say thanks for the replies that I have recieved. I
believe I am good to go now. I have done a few quick tests with the
replies that I got and so far it looks great.

I'd like to thank Reggie for explaining the response the way that it
is (if some of the books that I have only did the same I wouldn't need
to post for help)

Alex
ab*****@verizon.net (Alex) wrote in message

news:<7a*************************@posting.google.c om>...
I have searched the boards but I have not found what I am looking for
yet.

I have a form with two combo boxes. When the user makes a selection
in both of the combo boxes the information will look through two
tables and return the appropriate matches. This will be very small
scale at the beginning but once I get everything working it will
include more tables and dozens of matches to be returned.

I would like the information to print to a report and not on the form.
I do not understand how to get the information into a report however.
I have seen some posts mentioning going through a query first but
again I do not understand how to do that also. The user will have
access to nothing but the form which will have a few command buttons
on it.

I am trying to teach myself Access so any help here would be greatly
appreciated. If you could reply with an example that would be even
better.

Thanks for the help.

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.