Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 11th, 2007, 07:32 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 518
Thanks: 0
Thanked 0 Times in 0 Posts
Default Combo box in report

How can create bombow box in report ?
I want to create combow box in report,
when click the report it ask list of table field in combow box ?

In property I change to BOMBOW BOX
and give in property control source &CONTRACTOR_ID


When I run the report, it ask the CONTRACTOR_ID
I want the it should display all CONTRACTOR_ID in combow box
from the contractor table how ?

please send the steps?

Thanks
Mateen



 
Old November 13th, 2007, 11:52 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Hi,

   Do you want to find a record on the form, or is this to launch a new form or report by Contractor? If the latter, then do this:

Create a combo box using the wizard, and tell it you want to get the values from a taboe or query inthe database.

Then select the table with the contractorID, then select the field ContractorID - if you just want the ID. The order Ascending.

That should do it.

Let me know if you still have questions.


mmcdonal

Look it up at: http://wrox.books24x7.com
 
Old November 13th, 2007, 11:53 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Oh, I completely missed that you want a combo box in a report. This can't be done.


mmcdonal

Look it up at: http://wrox.books24x7.com
 
Old November 14th, 2007, 11:33 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

You do not place comboboxes in reports. They go in forms. You put it there and choose a contractor. Then have a button next to the combobox with code similar to this

DoCmd.OpenReport "YourReportName", acViewPreview, , "[YourContractorField] = '" & Me.YourComboboxName & "'"

This will open the report and only give those contractors you seek. Change YourReportName, YourContractorField, and YourComboboxName to your actual names instead of my fake ones.




Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
 
Old November 20th, 2007, 07:44 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 518
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks a lot

Mateen







Similar Threads
Thread Thread Starter Forum Replies Last Post
Combo box to display items from parent combo box Gini Visual Studio 2008 0 June 18th, 2008 12:30 AM
Combo box choice creating filtered combo box stevensj5 Access 11 September 13th, 2007 11:33 AM
Show all values in a combo box in a report Odeh Naber Access 3 July 24th, 2007 07:37 AM
Generating a report from a combo box toddw607 Access 7 March 26th, 2007 12:38 PM
How to generate report based on combo box selectio method Access 7 December 16th, 2005 08:01 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.