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.