how to use "multiple-items" form in continious view, click a row to open edit indivdu

[prashant862000]

Hi,

I have an access database, i used multiple-item continious view form. I need the ability to click a particular record in this view to open a individual record edit form window.

[jimatqsi]

Make a new form that edits one record. Then in your original, continuous view form, add a button to click, or use the click event on some object already on the detail line. In the click even of the button or other object, use docmd.openform to open the edit form you made. Use the where criterion on the openform command to tell the form which record it will be editing.

Jim

[mcupito]

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "YourFormToEdit"
    
    stLinkCriteria = "[TheFieldYouWantToLinkTo]=" & Me![FieldYouWantToLinkFrom]
    DoCmd.OpenForm stDocName, , , stLinkCriteria

On the [Event Procedure] OnClick of a button, here is some sample code. Hope this helps.

[prashant862000]

@mcupito yes, this perfectly helped me! Thanks :)

[mcupito]

Great! Glad I could help.