Linking data to each number in a drop-down box

[Guest]

This is my first attempt at building a database.
I have a drop-down box in one form with numbers 1 to 4. The rest of the
data in the form should relate only to one of the numbers 1 to 4. In other
words, having filled in the information relating to 1, I then want to change
to (Term) 2 and fill in the information relating to 2, but wish the
information relating to 1 to be saved.

 

[John Vinson]

This is my first attempt at building a database.
I have a drop-down box in one form with numbers 1 to 4. The rest of the
data in the form should relate only to one of the numbers 1 to 4. In other
words, having filled in the information relating to 1, I then want to change
to (Term) 2 and fill in the information relating to 2, but wish the
information relating to 1 to be saved.

Stop.

If you were building a house, you'ld pour the foundation first; then
assemble the walls; then install the windows.

You're starting with the windows.

A Form is JUST A TOOL to enter data into a Table. You need to start
first with your tables. I have no idea how to help you with your table
structure, since I have no idea what sort of information you're
dealing with, though!

Check out some of the references at

Jeff Conrad's resources page:
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html

and

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

particularly the Database Design 101 links on Jeff's page.

John W. Vinson[MVP]