Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
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 June 22nd, 2004, 07:04 PM
Authorized User
 
Join Date: Jul 2003
Location: Melbourne, Vic, Australia.
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default Combo Box Parameter Query

I have just discovered how you can run a parameter query using a list from a combo box. I have included a link to you reading my convoluted way of discribing the technique. http://www.fontstuff.com/access/acctut08.htm).

What I don't understand is how you can get the query results linked to a form, as you cannot run the parameter query from within itself and so cannot link it directly to a form.

Any help would be greatly appreciated.

Stephen

 
Old June 23rd, 2004, 09:30 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: , , USA.
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts
Default

Steve,

You need to create a second form to display the results of your selection criteria instead of displaying them in query view.

Create a new from by selecting 'Create form by using wizard' in the database window.

On the Wizards first page:

1. Select 'Query: qryStaffLocator' form the Tables/Queries dropdown list.

2. Move all Available Fields to the Selected Fields list (FirstName, LastName, Office, Department).

On the Wizards 2nd and 3rd pages select columnar layout and standard style (or whatever you like).

On the Wizards last page:

1. Name the form 'frmStaff'.

2. Select the 'Modify in Design View' option button.

When the form opens in design view, simply close it.


Go to the code window behind your selection dialog form (frmStaffLocator)

Change this line:

DoCmd.OpenQuery "qryStaffLocator", acViewNormal, acEdit

to this line:

DoCmd.OpenForm "frmStaff", acNormal

Now open your frmStaffLocator dialog, select criteria, and press OK. Your form will open and display records that meet your criteria, instead of your query.

What you have done is set your frmStaff's Record Source property to 'qryStaffLocator' which you can see by clicking on the Data tab of the form's properties window when you are in design view.

Post again is you have further questions.

Bob



 
Old June 24th, 2004, 06:30 PM
Authorized User
 
Join Date: Jul 2003
Location: Melbourne, Vic, Australia.
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

BOb,

Took me a little while to get my head around this but it works like a charm. Many many thanks for your assistance.

Stephen

 
Old June 24th, 2004, 08:44 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: , , USA.
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts
Default

Your welcome, Stephen. Glad you got it up and running.

Bob





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
Not able to pass the combo box value to SQL query sparsh2010 Access VBA 3 July 26th, 2006 07:10 AM
Query based on combo box selection help Elain Access 1 January 3rd, 2006 11:33 PM
Combo Box Parameter Query stevewardau Access VBA 2 June 24th, 2004 06:32 PM





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