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

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