Populate data from access

[bishop]

I have a 3 comb boxes. I want to be able to pick from these combo boxes and have it populate a field. I just do not know how to set this up.

cboCategory
cboSubCategory
cboExercise

I have attached an excel sheet that I want to create in Access or if it is easier to have Access populate the rows in Excel with the information from the combo box selections. The data that it will be pulling from is the Workout Log Form.

Any help is appreciated.

[June7]

You bind the comboboxes to the field data needs to be saved in. Check out these tutorials
http://www.datapigtechnologies.com/f...combobox3.html
http://www.datapigtechnologies.com/f...combobox2.html

Actually, the only value you need to select is the Exercise. The Category and Subcategory details could always be retrieved in query that joins tables. This is a principle of relational database - don't duplicate data. However, instead of saving the full exercise name, save a record ID. Check out 'sticky' thread tutorials here http://forums.aspfree.com/microsoft-access-help-18/