Can I click on a part number in layout view of a form and have it open a new form?

posterman

New member
Local time
Today, 15:14
Joined
Sep 29, 2008
Messages
8
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 think what threw us a curve is wanting to do this in Layout view. Form view yes, but I believe Layout view is a design view.
 
I helped without even knowing it! Like Allan, I though Layout view was a design view. Are you able to interact with data in this view?
 

Users who are viewing this thread

Back
Top Bottom