Best way to auot populate form

[bishop0071]

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.

 

[John Big Booty]

You can use the following in an unbound text box to populate it with data that forms part of a Combo Box's Row Source;

=ComboName.Column([B][COLOR="Red"]x[/COLOR][/B])

Where x is the number of the column in the combo that holds the data you wish to display in the text box. Remember that the columns in a combo are numbered form Zero on up. That is the first column (often bound and hidden) is Column(0) the second Column(1) and so on. It is not necessary for the column to be visible in the Combo Box, but it must form part of the Combo's row source.

 

[bishop0071]

Thanks for your feedback. I am not all that familiar with working with Access. Anyway you can show me how this would be set up and I can take it from there?

 

[John Big Booty]

Have a look at the attached.