how do I add Composer to the Music Collection database?

[qbertram]

The Music Collection Wizard in Access 97seems to be just what I need for my
CDs, minidiscs etc, except that it doesn't have a Composer section. How do I
add this?

 

[Al Camp]

qbertram,
Add a new field to the table called Composer (text 50 or so...).
If your form uses a table as the RecordSource, you can place the new field on the form.
If your form uses a query as the RecordSource, make sure the Composer field is included
in the query design grid, or SQL statement.
Correct the Tab Order for the new field, and you should be set to go...

 

[qbertram]

Thanks Al - problem fixed.

qbertram,
Add a new field to the table called Composer (text 50 or so...).
If your form uses a table as the RecordSource, you can place the new field on the form.
If your form uses a query as the RecordSource, make sure the Composer field is included
in the query design grid, or SQL statement.
Correct the Tab Order for the new field, and you should be set to go...
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions