I have 4 combo boxes on a report for the fields, City, County, IBCCP
Agency Name, and Other Agency Name.
The row source for City is: SELECT DISTINCTROW [Cities].[ID], [Cities].
[City] FROM [Cities];
This allows the values selected on the combo box on my main form to
show up on my report.
The row source for County is: SELECT DISTINCTROW [Counties].[County
Code ID2], [Counties].[County] FROM [Counties];
This also returns the values selected on the combo box on my main form
to show up on my report.
However, I am not successful in getting the correct row source for the
fields, IBCCP Agency Name, and Other Agency Name.
Can you help point me in the right direction?
Thanks,
John 1 1547
You can't have a combo box on a report. I know theoretically it appears
there, but use a text box instead. The report should be based on a query
that has all the results of the lookups displayed.
So if your form uses a combo box to select a county, you probably have
CountyID in the recordset for the form, but you would not have the Table
Counties.
In the query for your report, you would have your main table and the
counties table (suitably linked together) and show the name of the count
HTH
Phil
"zufie" <jo***********@ illinois.govwro te in message
news:cd******** *************** ***********@8g2 000hse.googlegr oups.com...
>I have 4 combo boxes on a report for the fields, City, County, IBCCP
Agency Name, and Other Agency Name.
The row source for City is: SELECT DISTINCTROW [Cities].[ID], [Cities].
[City] FROM [Cities];
This allows the values selected on the combo box on my main form to
show up on my report.
The row source for County is: SELECT DISTINCTROW [Counties].[County
Code ID2], [Counties].[County] FROM [Counties];
This also returns the values selected on the combo box on my main form
to show up on my report.
However, I am not successful in getting the correct row source for the
fields, IBCCP Agency Name, and Other Agency Name.
Can you help point me in the right direction?
Thanks,
John
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: hawk |
last post by:
I am creating a series of custom reports, whose parameters are
specified through combo boxes in a form, which then generates a custom
report based on a series of calculation queries. My problem is
this...at the top of the report I've inserted several text boxes which
link to the combo boxes on the entry form, and are supposed to show
which parameters a particular report is being generated from. On the
screen, everything looks great and...
|
by: Dalan |
last post by:
I have been searching the archives in an effort to discover how to
derive a dual use of a single combo box - so far no go. I found the
piece below which pretty much represents the usage. To summarize:
The cboKeyword box on the frmCustomer looks up Keywords from a
separate table that have just a list of keywords and a KeyID number.
The bound column is tied to the autonumber and is saved in the
frmCustomer table. The keywords appear in the...
|
by: RBohannon |
last post by:
I'm using Access 2000.
I currently have a report being generated using the results of a query
by form. The form used for this query is an unbound form,
frmListDialog. frmListDialog contains two unbound text boxes,
txtExamTitle and txtExamNumber. The user enters either the exam title
in txtExamTitle or the exam number in txtExamNumber as a parameter for
the query. This is currently working fine, however because the exam
titles are...
|
by: pelcovits |
last post by:
I am trying to set up an unbound form to enter report criteria.
I've followed the MS Office Assistance document: "Create a form to
enter report criteria" which describes how to enter data (such as
dates) in a text box. This procedure works fine. However, I also need
to enter data from a combo box and I cannot get this to work. On my
form I've created an unbound combo box named "Name". In the query bound
to the report I've entered the...
|
by: meganrobertson22 |
last post by:
Hi Everyone-
I have a question about how to add and then use the "All" selection in
a combo box. I am trying to figure out how to:
(1) add "All" as a selection to a combo box and then
(2) how to use the selection "All" as criteria for a field in a
query, which is used to generate data for a report.
| |
by: Miguel |
last post by:
I have synchronized combo boxes linking Account Type with Customer
Names based on the template that Microsoft has in one of its samples
databases. There are the appropriate relationships between the Account
Type Table and the Customer Name Table based on the ID field, so it is
the ID field which is stored in the main table. However, in the form,
the Account Type and Customer Name are displayed because the column
width property has been...
|
by: mumbaimacro |
last post by:
hi
i have two combo boxes in a form with values from a table.
i need a report to be opened by a button from the form ,The Report should show the values selected in the combo boxes in the form and also i am going to show some other values from tables in the report with that.
example:
form view:
month: jan --> selected from combobox
year : 2006 --> selected from combobox
|
by: consonanza |
last post by:
I am working on a report filter form. It has 2 combo boxes
(cmboSelectSubject and cmboSelectCategory) to select criteria.
Selecting an entry in combo 1
restricts the options available in combo 2.
The row source for combo2 is:
SELECT DISTINCT tblComplaintCategory.fldComplaintCategory,
tblComplaintCategory.fldComplaintCategoryID,
tblComplaintSubjects.fldComplaintSubjectID
|
by: BeaBea |
last post by:
Hi All,
I have been reading some of the threads in your forum and decided to join and post my question. Hopefully it won't be too lengthy.
I have created an Unbound Form called paramform2. This form contains two combo boxes, a text box for the start date, a text box for the end date and a command button that runs the report.
The first combo box is named FindMgr. The row source of this box is set to: SELECT"All" As MgrName FROM...
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |