Selected in Combo Box not showing up (1 Viewer)

Hi,

The attached database example has two tables (tbl_Documents and tbl_RepPeriod) and a form that is being used to populate this information.
The form (TestForm) has a combo box that lists "Active" reporting periods that the user can select from to assign to each of the records from the tbl_Documents. The combo box list the active periods which are enable/disable from the tbl_RepPeriod.


In this current example record ID # 4 from tbl_Documents has been assigned in the past a Reporting Period = "2017-09". This period has been later disable and therefore is not being listed when I click the drop down menu of the form and which is the expected behaviour.

My question:

Is there a way to still see the assigned Reporting Period while scrolling through the records in the Form even though now this period is disable?

I hope the question is clear.

Thank you

chevk the code behind the form

arnelgp said:

chevk the code behind the form

Click to expand...

Dear arnelgp,

Thanks for your prompt response. This is exactly what I was looking for.

Thank you

no probkem. goidkuck and happy coding.