Hi, Ive set up the search box exactly the same way as the Chemical name one. I've re-typed the code in but it's still not working.
This is the code for the chem name search DoCmd.OpenForm "basicFm", , , "ChemicalName Like '*" & Me.ChemicalSearchBx & "*'"
And this is the code for the formula search DoCmd.OpenForm "basicFm", , , "FormulaTXTBx Like '*" & Me.FormulaSearchBx & "*'"
When I click on the chem search it works fine, opening the basic form with the correct info but when I try the formula one it opens a Enter parameter value pop up box, then even if I put a formula in there it opens the same basic form with the wrong info.
What am I missing?