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 March 26th, 2009, 07:34 AM
Registered User
Join Date: Mar 2009
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default how do i create a subform which displays query results?

hi im currently trying to complete an access project involving a music player creation.

i've created a form to search through the database for specific songs (e.g by title, artiste etc.). how do i create a subform in the form so that users can type in their search in the form and see the results in the subform just below?

thanks alot for the help
Old March 26th, 2009, 02:34 PM
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

In a nutshell:

Use the wizard to create a subform in datasheet view of all the data. Format it as desired and save it.

Open your main form and click the toolbox's subform button and place a subform control in your main form. Don't make the subform control bound or related to the main form as the wizard may ask you to. Make sure the source object of the subform control is the subform you recently created.

When you open the main form, the subform will show all data. Your next step is to write an afterupdate event for the dropdown box on the main form. The update event will apply a filter to the subform that will then limit the records to those matching the data in the dropdown list you selected.
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do i create a subform which displays query results? tangwt Access 1 April 6th, 2009 08:31 AM
Edit Query Results in Results Grid druid2112 SQL Server 2005 1 June 28th, 2007 08:49 AM
Update subform results? dstein4d Access VBA 0 February 8th, 2006 05:23 PM
How to create a report that displays the meta data method Access VBA 1 April 4th, 2005 06:40 AM
Webservice displays only 1 instead of ALL results eli2003 .NET Web Services 0 September 9th, 2003 12:33 PM

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