Populating combobox and displaying on a report - RESOLVED

Hey guys,

I'm developing a DB with Access 2000 and VBA, and was hoping you could help me. Right now, the problem I'm stuck on is this: I've got a group of 3 option buttons on one form. The option buttons correspond to fields on a table I've made.

Anyways, when the first form exits, I open a new form, which contains a combobox. I would like to have that combobox populated with the corresponding data from my table. For example, if I had option 1 selected on the first form, I'd like the second form's combobox to contain the data in field 1 from my table.

After that, I'd like the value selected in the combobox to fill in a text box on a report.

It doesn't sound that complicated to me, but I can't figure it out for the life of me.

Thanks.

I know it's not cool to bump my own thread, but I could really use some help on this, if anyone could spare a little time.