How to filter selections for combo box (1 Viewer)

[HelpNewtoAccess]

Hello,

How do I filter selections for a combo box on a form. I have a multiple reports that have many records and I want to bring up a form with a combo box that just allows me to select one of these records based on the report. I also do not want to see the rest of the records in the combo box.

form1(command button)
DoCmd.OpenReport "rptElevators", acViewReport, "", "[BldgAbb_ID]=""AFC""", acNormal

report(command button)??
DoCmd.OpenForm "frmElevatorsEdit", acNormal, "", "[BldgAbb_ID]=" & "'" & BldgAbb_ID & "'", , acNormal

form2 (frmElevatorsEdit)
opens with 2 records don't know how to do with combo box

Thanks

 

[Uncle Gizmo]

I also do not want to see the rest of the records in the combo box

Please explain the criteria you use to decide which records you want to show in the combo-box.

 

[HelpNewtoAccess]

The combo box on form 2 shows all the records for all the elevators based on a query. I just want to see the records from the report in the combo box on form2.

(Name of combo box cboElev and fields are ElevNumber and Building.)

 

[Uncle Gizmo]

I just want to see the records from the report in the combo box on form2.

Please explain the criteria you use to decide which records you want to show in the combo-box.

 

[Isaac]

Maybe you could open a Recordset based on the report's recordsource, go through the Recordset and set the combo's rowsource accordingly.
IF I understood you correctly .........