Form fields to Report - Microsoft Access / VBA

mbolokofsky

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

Subscribe Post Reply

1357

OldPro

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

Similar topics

Problem with 'Filter By Form'

by: CSDunn | last post by:

Hello, I have a problem with field filtering between an Access 2000 Project form (the application is called CELDT), and the report that shows the results of the filter. Both the form and the...

Microsoft Access / VBA

Parameter query returning information in form view

by: Simon Pleasants | last post by:

Am something of a newbie at this, so please bear with any stupid questions. I have created a database to track shipments that we import. The information is stored in a table and I have created...

Microsoft Access / VBA

Custom Reports by Form input (user picks report options on Form and gets report showing options picked)

by: RC | last post by:

I can't quite grasp the concept of creating custom reports depending upon what options a user picks on a Form. For example, the user clicks on a "Print Reports" button and a Form pops up. On the...

Microsoft Access / VBA

Using a picture (Form Template) as background in a report?

by: Salad | last post by:

Hi: I have a Bill of Lading template from the printer that I saved as a BMP. I created a new report and in the report's picture property told it the BMP file name. It brought the image in just...

Microsoft Access / VBA

Strange Results w/ Form page POST Method

by: Bill | last post by:

I'm using the POST method to submit a simple form html page with yes/no and checkbox fields to an asp response page which stores the values in a new dim string, then uses it to build a new table...

ASP / Active Server Pages

Report the current filtered records from a Form

by: melnhed | last post by:

---Report the current filtered records from a Form--- Hello All, I've seen this topic discussed before, but the solution described then doesn't work in my particular case. My Config: ...

Microsoft Access / VBA

Report the current filtered records from a Form (in an ADP project)

by: radio1 | last post by:

---Report the current filtered records from a Form (in an ADP project)--- Hello All, I've seen this topic discussed before, but the solution described then doesn't work in my particular case. ...

Microsoft Access / VBA

Print multiple records from a Form into a Report

by: Dave | last post by:

On my form I have combo boxes. These combo boxes, after updating them, populate respective listboxes that are located below the combo boxes on the same form. I am trying to use a "generate...

Microsoft Access / VBA

E-mailing current record on form

by: easydoesit | last post by:

Hello all, I am looking for a way to be able to enter data into fields on a form, then be able to e-mail a report that shows only that record. This is what I have thus far: At the end of my...

Microsoft Access / VBA

Opening a report from a form so that the last report is visable and sorted by a field

by: daverskully | last post by:

Table: Data Form: Entry Form Fields: 1) Department 2) DepartmentNumber 3) AccountExecutive 4) ReportDate 5) ID 6) 7 yes/no fields

Microsoft Access / VBA

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing