MS Access Help needed

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

oggie666

Thread Starter
Joined
Aug 13, 2003
Messages
59
I am in the process of creating a database, and have only just started to use access.

I am wanting to create a Drop down list box on a form. I want to do it so that whatever option i choose on that particular record, doesnt carry over to the next record.

EG. If i was creating a music database to catalogue all the music i have on all different types of media, i would like to be able to create a drop down box, so i could select CD for the first record, Then tape for the second record, maybe CD for the third record, maybe Vinyl for the fourth record etc......

The only problem is when i try and follow the instructions it all becomes confusing and i end up getting All records with the same option.....

Eg I put CD in the first record and when i go onto the second record to choose Tape, i go back to the first and that also now says tape....

I know this is a bit long winded but any help is appreciated
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,749
oggie, can you upload your DB? You've got something wrong...

You should have a table called "formats" or something. In it you should have the following fields:
FormatID
FormatDesc

Then, in your main records table, you should have a field called Format. For the data type, choose Lookup Wizard, and do a lookup to the Formats table. Choose BOTH fields, but let it hide the ID field.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top