It is already checking that because the barcode combo's rowsource is based on the barcodes table. You can change the rowsource to limit it to just the active barcodes or you could add code to the before update event to check if the barcode is not active and prompt the user -see the updated file.
Cheers,
Vlad