I am using Access 2007 and have an issue I’m hoping you can help with.
I have a form (frmSearchMain) with a combo box (cboSearchType) from which you choose a search type and a text box (txtSearchString) where you enter the search string and a button (btnSearch) that runs a query and opens a new form (frmPartNumListReport) in layout view.
In this case I am using the Part Number search type and entering a partial part number; after clicking the search button the query runs and the new form, frmPartNumListReport, opens in layout view and lists all part numbers starting with the partial number I entered. This is all working as intended.
I would like to be able to click on a particular part number in frmPartNumListReport and have it open a new form, frmPartNumSearch, which displays all the pertinent information for that part number. I have the form frmPartNumSearch created. My dilemma is figuring out how to click on a particular part number in layout view and have it open the new form.
Any help would be greatly appreciated.
Thanks in advance for your help.
Paul
I have a form (frmSearchMain) with a combo box (cboSearchType) from which you choose a search type and a text box (txtSearchString) where you enter the search string and a button (btnSearch) that runs a query and opens a new form (frmPartNumListReport) in layout view.
In this case I am using the Part Number search type and entering a partial part number; after clicking the search button the query runs and the new form, frmPartNumListReport, opens in layout view and lists all part numbers starting with the partial number I entered. This is all working as intended.
I would like to be able to click on a particular part number in frmPartNumListReport and have it open a new form, frmPartNumSearch, which displays all the pertinent information for that part number. I have the form frmPartNumSearch created. My dilemma is figuring out how to click on a particular part number in layout view and have it open the new form.
Any help would be greatly appreciated.
Thanks in advance for your help.
Paul