Inactive/Active Fields

[Novice1]

I have a field in a table which is linked to table2. In table2 I have ORGN (text field) and Inactive (Y/N field).

In a form I want the ORGN field to only show active records (Inactive "N"), which I can do; however, if I make the ORGN inactive, then none of the previous input records will show the ORGN (blank).

I want only active records to show upon input but once the data is selected not to disappear.

Any help would be appreciated.

 

[Ranman256]

How are you filtering?
Filtering on Inactive should not hide the active records