show query data in report

[daMike]

Hello,

maybe the question is a little bit silly, but how can I
conncect a query-table with a report? I already created
the query and this result should act as source for a report.
Does it work with VBA? I tried it with the assistant and it
worked pretty well!

Thanks a lot!
daMike

 

[Colby]

Create a new form in Design View. If you right click on
either the window bar of the new form, or in the top left
corner there is a small box where the horizontal and
vertical rulers come together, and go to properties, you
will be able to see the properties for the whole form. Go
to the data tab and set the Record Source to the query.
This will bring up a box that displays the values that are
available from your query. From here you can drag those
boxes onto the form and use them how you wish. You will
also be able to edit the data in VBA by using their query
alias as if it were a variable name.