after Private Sub MolWeightSerachBt_Click() add
Debug.print "(1) " & [Molecular WeightColm]
debug.print "(2) " & Me.MolweightSearchBx
save code and run again. If you don't get a value in the immediate window beside 1 and 2, your references are returning no values.
When finished testing, remove or comment out the added lines. Alternatively you could use a message box rather than printout.
Last edited by Micron; 07-25-2019 at 08:37 AM.
Reason: code correction
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.