Form filter with multi-column combo box in report

I have a form containing some text fields (orders) as well as a combo box 
(customer id and name).

The record source of the form is a query joining the two tables order and 
The control source of the combo box is the customer id from the above 
mentioned query.
The row source of the combo box is the customer table, containing the two 
columns id and name.

The first column of the combo box, the id, is bound.

The report contains the same fields as the form. The two columns of the 
customer form combo box are represented in the report as two text boxes.

The record source of the report is the same query as the one of the form.
The control source of the two customer text boxes is the customer id and the 
customer name from the above mentioned query.

If the width of both columns in the customer combo box is greater than 0, I 
can set a form filter on that control and then generate the report with the 
same filter. No problem there.

But if the width of the bound column is zero (as the users are interested in 
the customer names, not their id), I am asked to “enter parameter value” for 
the customer name before the report is generated. The report is then 
generated with no records at all.

How can I generate a report based on a form filter with multi-column combo 
boxes when the width of the bound column is 0?

If this does not work at all, does somebody have an idea for a workaround?

Any help is appreciated!
2/10/2010 1:05:01 PM
access.reports 4434 articles. 0 followers. Follow

0 Replies

Similar Articles

[PageSpeed] 58


Similar Artilces:

Excel 97 dropdown function box
The dropdown function box on the Formula Bar show formulas but will no longer show "More Functions". How can I get this item back? ...

Another multiple criteria/column question
Ok, first post and pretty much a new user to Excel. I have two sheets that I am working with, trying to recall data from one to the other that meets criteria. In a nutshell: Sheet 1 contains a column of unique values (col A), cols C,D, and E are where I want to insert the formula to find data on Sheet 2. Sheet 2 contains 4 columns, A contains multiple occurrences of each value (from Sheet1, column A), each with its own timestamp in column D. On Sheet1, in column C, I want to find a value on Sheet2 in column A and return the timestamp in column D. I know I can use VLOOKUP for this. =VLO...

How to shift address listings from row list to columns?
I have a mailing list with name, address, city, state & zip with each item in individual rows like a list of labels and a few empty rows of space between each listing. How do I create/transfer this list into columns accross so I can sort by city or zip? Thank you! If your data is nicely grouped, with each group in 5 lines, viz: name add city state zip then an earlier suggestion given which worked might be worth a try: See: -- hth Max ----------------------------------------- Please reply in newsgroup Use xdemechanik <at>yahoo<dot>com for email --...

Excluding hidden columns and rows when copying to another workbook
When I print part of a worksheet that has hidden columns and rows - the hidden columns and rows do not print. That's what I want. Now--I'd like to take that same data and copy it to another workbook excluding the formulas and hidden columns and rows so that the new file contains only the data as was printed. How can I do that? PJ Select your range including hidden rows and columns then Edit>Go To>Special>Visible cells only>OK Now do your copy/paste. Gord Dibben Excel MVP On Fri, 6 Feb 2004 10:16:07 -0800, "PJ" <> wr...

Date format in a report
The date is formatted in my table in yyyy/mmm/dd. In one report I need to run for another organization the format needs to be in dd/mmm/yyyy format. How can I change the way it displays in the report? I do not want to change it in the table as I generally want the format to be yyyy/mmm/dd. -- Charlie You can simply use either the format property for the control or you can use the Format() if you need to set the format to something that doesn't already exist. Format([YourDataFieldName],"dd/mmm/yyyy") -- Hope this helps, Daniel Pineault http://www.carda...

Sorting with Column has Formula
Hi everyone, I never imagined that the formula in the column would affect the sorting order in any way, but it does in my case. Below is the formula in that I have in Col I, and I'd like to sort it in Ascending order, but the result is that it sorts with all the empty rows on top and the one with the result from the formula at the bottom. I assume it consider the "I" in the "IF" function in the formula, but I'm not sure. Can anyone tell me how to fix this please? =IF(E2="","",IF(J2="X","Priority #1",IF(...

generate report thru pracle to excell
Recently i upgraded to ms office 2003 since then I'm not able to generate reports thru oracle unto excell (online ). But when I log in an administrator in the local system I'm able to generate the report. the same does not happen with domain users ...

Exchange 2003 Content Filtering
Hi All, Is there a way, through Exchng 2003, to block e-mails that contain certain words like "viagra" etc. If so, where abouts do you do it? Any help appreciated TIA Mark Grab the IMF (intelligent message filter). "Mark Griffiths" <> wrote in message news:EtLIe.20643$ > Hi All, > Is there a way, through Exchng 2003, to block e-mails that contain > certain words like &quo...

Report Detail section coding
Is there a way I can know when the detail section of report moves to the first record of a new group. Something like..... If Me.DetailSection.BOF Then I am using Access 2007 Any help is always appreciated. Thanks, Wally wallymeister wrote: >Is there a way I can know when the detail section of report moves to the >first record of a new group. Something like..... > >If Me.DetailSection.BOF Then > >I am using Access 2007 Add a text box to the detail section and set its expression to =1 and RunningSum property to Over Group. The value of the te...

Report: "You have no transactions for the item you selected."
Hi, I've run into a glitch I can't figure out. I'm working with the Monthly income and expenses report. There are amounts listed under the Income - Unassigned category. When I double-click the category to see the transactions, I get the message in the Subject. I did a split-half search to find the supposed account that it registering the amount, but cannot find any transactions that are in error. I tried a Standard Repair without any change. Help! I should add that this is Money 2007. "Robert Berus" <> wrote in message news:OFn...

Controlling printed records when report bound to multiple tables
I created a report that uses the control from a form to generate a report based on that record's primary key. This form also has a subform which has relationships tied to the primary key for record identification and is linked to the main table. When preview the report the data from the subform either does not show up in the preview when using the filter [control]=[form]![control].[value] or makes multiple copies of the report equal to the number of entries in the subform's table. Is there any way around this? I have tried queries but have not found a way to use a f...

Varying column widths
I have 2 excel sheets - one is 20 columns wide the 2nd is 7 columns wide. The 20 column sheet has a general information section at the top that I would like to add to the 7 coulmn spreadsheet. However, when I copy and paste it "spreads out" or goes way beyond the width due to the number of columns. I have tried paste special object and entering the excel sheet that way and it doesn't fit properly and too many cells are shown. Any other way to do this? If you only want it up there for appearance purposes, you can try: Copy the selection. Click the cell where you want t...

retain only rows with condition that cells in column H containing "AU"
I have a large database containing columns with one column specifies the product name. In one instances, I need to retain only rows with condition that cells in column H containing "AU" of the entire string in the cell. Delete those rows without it. The problem is , that the AU of the string can appear in any position, not a fixed position. Is there any simple way of doing it? Many Thanks! Regards, Bora Hi, You can use AutoFilter. Choose the command Data, Filter, AutoFilter. Then open the autofilter drop down in the column H and choose Custom and from the first drop down, t...

validation list or combo box dependant on cell value
Am i able to determine the values shown in either a validation list or combo box being dependant on a value in another cell? ie: Cell A1 = BOB then validation or combo box would then base it's list from the named range (or whatever the solution may be) based on Bob. if i was to change A1 to ROY then it would also change the underlying list? I have tried everything that i think SHOULD work but that it pretty limited... thanks in advance rich I'd start with Debra Dalgleish's site: Richard Edwards wrote: > > Am i able to deter...

Report of Employees not paid
What do you think would be the easiest way to generate a report for a pay period showing anyone who had not been paid that pay period--like a payroll exception report for anyone with wages = 0 for a given pay period. Thanks! -- Debbie from Wipfli It's easy to do outside of GP. If you had MS Access or can write a SQL query in SQL Server Query Analyzer, you join the Employee Master table (UPR00100) with the Check History Table (UPR30100) but restrict it to where the values in the joined fields in the Check History table are null. MS Access has a wizard that will create the query for...

Radio Button on opening the form
Hello: I have know how to open the form using command button, but now I want to use Radio Option button to open the form consists of: 1. Show all supplier invoices 2. Show only outstanding invoices 3. Show only paid invoices I have created 3 types of Form using 3 types of query, and now I want to open it by using radio button with the button OK and cancel to open the form. Is there any website providing the sample of Radio button to opent the form. I want to studdy how to write the VBA for that. Thanks in advance. Frank You sure you want the form to open when the radio button is sel...

Equivalent Column Break
In MSWord you can insert a column break when doing newspaper columns. If I have two text frames connected, and I am almost at the bottom of one but want Publisher to start at the top of the next one, how do I insert a 'break'? or do I have to press return until it move the text. Thanks Anita (1) You could shorten that column so that your text breaks where you want it to. (2) Or you could check the Help file and search for "insert break". Insert a column break You can insert a column break anywhere in a text box. If the text box contains more than one column, the ...

report prefiltering does not work for custom entity
Please help. I've been trying for days but can't get the reports prefiltering to work for my custom entity. I created a simple report with the CRMAF_ prefix and deploy to the CRM server. The report works fine and display all data OK. Except the pre filter does not work i.e. the "Edit Filter" button does not show. My question is: Does report prefiltering works for custom entity? I saw a lot of posts regarding this topic and tried all the suggestions i could find, but still no luck. I tried the microsoft tutorial in creating a prefilterable report base on the account...

need help Combo Box with duplicate entry.
I have a combo box with unique and non-unique entries. (search field) 00010 | john | smith | 12345 | 00002 00196 | jane | doe | 0120 | 00001 00196 | Jone| wood| 0220 | 00005 I would like the following to happen. 1) user types the number needed ( 10 ) 2) the combo box zero fills the field (00010) 3) then selects an entry from the combo box. (12345) if the select is incorrect ( one of the non-unique numbers was selected - 00196) the user will open the combo box and select the correct entry. (jone wood) add the info will be put on the form. the following code works if the user ente...

how to compare 2 values in a report (Invoice Total vs Payments)
while running a report how would I set a message "out of balance" if my invoice amount (Table 1 ) does not equal the value of my total payments (table 2). If the values were the same then no message would be printed. Thank You Create a new command button to check the report before you print it. You will have to enter code for the button along the lines of: If [Invoice Total] <> [Payments] Then MsgBox "This account is out of balance" Endif "Rita" wrote: > while running a report how would I set a message "out of balance" if > my invo...

Hiding Column and Row Bars.
I know theres a way to costumize the way you view an excel page by hiding toolbars, but is there a way to hide the rows and column bars just so all you can see is the actual page. E.G. is there a way to Hide the top bar that defines the colums "A", "B", "C","D" and Rows 1,2,3,4,5. Go to Tools>Options>View, there are a number of options you can play with there. -- HTH RP (remove nothere from the email address if mailing direct) "tamato43" <> wrote in message news:7D1E5DEB-D6F2-47C8-95E2-2...

Column comparison
I am trying to compare 2 columns of numbers so that I can identify and delete numbers no longer required. Can anyone help me find a formula for this please? Many thanks DT Hi Dave, Need more information like a sample of the existing data plus a sample of what you want left. Maybe an explanation of the criteria for what needs to be deleted. -- Regards, OssieMac "Dave T" wrote: > I am trying to compare 2 columns of numbers so that I can identify and > delete numbers no longer required. Can anyone help me find a formula for > this please? > > Many than...

Disallowing duplication of nmbers in a column
Is Excel capable of disallowing the same numbers in a column? I have a column in a sheet that invoice numbers are entered into. I would like that column to alert or something if duplicate numbers are typed in. Hi Have a look here: -- Andy. "Barb1" <> wrote in message > Is Excel capable of disallowing the same numbers in a column? I have a > column in a sheet that invoice numbers are entered into. I would like > that > c...

Auto Filter not working
I have a strange problem which occurs from time to time whereby I am unable to activate the Auto Filter function on a list. The filter buttons simply do not appear! Does anybody have any idea why this might happen?? Thanks, Chris J Is the worksheet protected? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC "Chris Jenkins" <> wrote in message news:bf9p58$app$ > I have a strange problem which occurs from time to time whereby I am unable > t...

Pop-Up Subform not linking to Main Form
I have a subform - frmLawEnforcement - that is accessed on the main form - frmCorporateSecurity - by clicking on a command button from the main form. The two forms are linked by the CaseIDNumber field. If I place the subform as just an entry from with the main form, the information shows as linking by the CaseIDNumber. When I enter the information into the subform using the command button, the information does not link to the case number. I am not sure what I could be doing wrong. I am an intermediate Access user but am fairly limited on VBA. ABradley, It would help...