Solved Active / Inactive Items List in combo box

[ahmad_rmh]

On which event I have to call for inactive items so that it could show the previous records of transactions with main and subform. The screenshot is attached herewith for your info please.

 

[ahmad_rmh]

I have solved through the following codes, Kindly suggest is this the correct way or suggest the best. thanks

Private Sub Form_Current()
Me.ItemsFK.RowSource = "SELECT ItemsPK, ItemsListName FROM tblItems ORDER BY ItemsPK;"
End Sub

Private Sub ItemsFK_GotFocus()
Me.ItemsFK.RowSource = "SELECT tblItems.ItemsPK, tblItems.ItemsListName, tblItems.IsActive, tblEntities.EntityPK FROM (tblCategories INNER JOIN tblItems ON tblCategories.CategoryPK = tblItems.CategoryFK) INNER JOIN tblEntities ON tblCategories.EntityFK = tblEntities.EntityPK WHERE (((tblItems.IsActive) = True) And ((tblEntities.EntityPK) = [Forms]![frmTransactionsMain]![MainWarehouseFK])) ORDER BY tblItems.ItemsPK;"
End Sub

 

[The_Doc_Man]

If you are using a field as a marker for activity, that is probably the most common method and is very commonly used.

 

[ahmad_rmh]

If you are using a field as a marker for activity, that is probably the most common method and is very commonly used.

Thanks Doc, I am asking about the events which I have used.