Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
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 January 18th, 2006, 02:43 PM
Registered User
 
Join Date: Jan 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to zuldan23
Default Using Combo Boxes to Complete a Query Question

What I have set up is a group of three combo boxes in a form. I also have a command button that opens a report based on a query. This query asks for three inputs to complete the report. What I want to do is have the answers to those questions filled in from the current record that is being looked at.

So a person is looking at a record and it says the location of the sample is Dewar: A, Can: 2, Cane: 31. Then when you open the report it asks for these three bits of information and I want them to be automatically filled in. Is this possible. Thanks
 
Old January 18th, 2006, 04:37 PM
Authorized User
 
Join Date: Dec 2005
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes this is possible.
You have a couple of choices that I know of.
But this one might be easiest.
You can name parameters by a path to the data you want
so say your form name is frmMyData and the 3 boxes you want to draw from are
txtData1
txtData2
txtData3

Then you can name your paramenters
Forms!frmMyData!txtData1
Forms!frmMyData!txtData2 and
Forms!frmMyData!txtData3
just right on your query.


So say the parameter was where cane = 31 in criterea, then you just type
Forms!frmMyData!txtData3 in the criterea section of the query.
Hope that helps

Enoch





Similar Threads
Thread Thread Starter Forum Replies Last Post
3 combo boxes ttkt Beginning PHP 0 July 2nd, 2005 02:20 PM
Combo Boxes tjs206 VS.NET 2002/2003 7 November 7th, 2003 04:45 PM
combo boxes damnnono_86 Access 2 October 15th, 2003 09:00 PM
Combo Boxes Louisa Beginning VB 6 2 September 10th, 2003 09:26 AM





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