Help with form

[bishop0071]

I am having such a difficult time with creating my form. I am not skillful in access so cannot find a way to set this up. I attached my database so it will be easier to see what I am looking to do. In my form I want to have 2 drop down boxes. When I click the drop down for BodyPart it will only show exercises for that category under drop down box for Exercise then I will click enter to have it populate that name. Then I would repeat the process for each additional exercise. Example:

BodyPart: Legs
Exercise: I would choose Squats
Click Enter

1. Squat

BodyPart: Legs
Exercise: I would choose Hip Bridge
Click Enter

1. Squat


2. Hip Bridge

etc....

Thank you

[rpeare]

What you're talking about is a cascading combo box. To be able to set that up you'd have to have tables like this:

tblBodyPart
BodyPartID  BodyPartName
1           Legs
2           Shoulders
3           Arms

tblExercises
ExerciseID  BodyPartID  ExerciseName
1           1           Squats
2           1           Hip Bridge

Then you'd have to have a table for your customers and their exercise regimen. Customers on one table (customerID, name and other information), Exercises per Customer on another table (CustomerID, ExerciseID, reps, weight, etc) on another table.

WHen you do your data entry you'd have an unbound combo box relating to the body part which would then be a criteria for the contents of the exercises you could choose from.

There are a million threads about cascasing combo boxes on this forum and other places

http://fontstuff.com/access/acctut10.htm