Combo Box 101 Help, plz 1

[benaround2]

I have a combo box on a form, frmBxA and I want it to populate 2 other boxes,frmBxB and frmBxC, when a user select a row in the combo box for a report to be run in Access 2000.
Is requery the how-to-do answer with a unique key? or is there a simple way with somehow addressing the record sets?
The record source query has FldA, FldB and FldC in it to be put into frmBxA,frmBxB and frmBxC parts of the form. I have set the row source type to Table / Query.

Thanks for your help.

 

[Remou]

You can set the control source for frmBxB and frmBxC to:
=[cboCombo].Columns(n)
Where n is the number of the column, starting at zero.