Hi, I have 2 forms, SearchFM and BasicFm.
What I would like to do in my SearchFm is type in variable text (in this case a chemical name) in an text box (ChemicalSearchBx), click a button (searchBt) and it to open my BasicFm with all the data related to the chemical name I typed in.
I have set up my BasicFm and linked it to my tables and I can use the navigation buttons to scroll through my data.
I tried to set a macro that on click of my searchBt that opened my BasicFm where [chemicalSearchBx]=[Forms]![BasicFm]![ChemicalName]. Chemicalname is the link to that field in my table.
I get a pop-up box to type in but it just returns a blank BasicFm.
How do I a) link my ChemicalSearchBx to my macro? So I don't get a pop-up box.
b) Get my basicFm to return with the data that matches when I've typed into ChemicalSearchBx?
Thanks