Report showing in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have form where I have entered a butoon (starts a query) which allows me to
search on keywords within a table. The result of running the query is a
report which just has 3 bits of information. I would like this report to be
seen as a window within my form rather than a stand alone report (it just
takes a small amount of room).

How do I do this?
 
In design mode for your form, drop the query into the body of the form. This
will create a subform that you can format to look like your report. Your
button will have to refresh this data in addition to calling the query. In
fact, you can combine all of this into one form by adding textboxes to your
form to feed the keyword to your query.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Access Report Works on One Machine but not Another 3
Problem with Report and Forms 2
Rounding decimal values in forms and reports 2
changing a filtered report to a filtered form 3
Print a report from a form based on a query 4
Getting a Form recordset to a Report 4
Creating a report from a form with multi tabs 1
Running a report for a specific record from a form 3

Back
Top