DROP DOWN BOX

  • Thread starter Thread starter steviegoodrich
  • Start date Start date
S

steviegoodrich

A friend of mine wants to create an Access database for his music
collection. He would like a form with all the data on, eg title, media,
artist etc, but for the track listing he would like a drop down box listing
all the tracks on the album. is this possible, if so how would he go about
it.
(new to access 2002)
thanks in advance
steve
 
Yep, its possible.

U need to use either a list box or combo box. When
creating the form, right click the mouse button and select
the toolbox option.

In this option, u can either select combo box or list box.
I'm not too sure what the difference is though.

Once u select either the combo box or list box,just follow
the wizard that appears!!!
 
Yes, it is possible. You need to look at "normalizing data". What you would
do is have one table with albums and a unique ID field in that table. In
another table you would have songs with a unique ID field in that table as
well plus a field for the album ID. You would then link these 2 tables
together on the album ID field in each table.

Now for the combo box, you would set the Row Source of the combo box to a
query that draws its data from the songs table WHERE the album ID in the
songs table matches the album ID of the current album on the form.

Next, what is he planning on doing with the combo box. Normally it is used
to make a selection from this list then do something with that selection. If
all he wants is the list, a list box may work better.
 
Back
Top