Swithing between Continous form and Single Form, selecting a record 1

[LimitedTech]

I would like to have a button on each line of a continuous form that will open a single form for the OrderID (text field) for that line. Is this possible? Essentially I want to see a list of items and if someone is inquiring about one of them be able to click the button to get the rest of the details and enter information for that OrderID.

Thanks

 

[MajP]

sure put a button in the detail section and it will appear for each record.
Then look at the docmd.openform method

https://msdn.microsoft.com/en-us/library/office/ff820845.aspx

The current record likely has a primary key. Then you use the openform method to open to that record. Something like

Private Sub cmdFilter_Click()
DoCmd.OpenForm "frmProduct", , , "ProductID=" & me.ProductID.Value
End Sub

 

[LimitedTech]

Perfect! Thank You!