Access 2016 Subform select record to open other form

Question

I am writing a call program in access 2016. Customer need double click a record in subform. And open a pop up form to show that record. However, I got a problem on capture the selected record value. Below is the code for double click action and I got problem on ".AbsolutePosition = Me.optChooseBase - 1". Could you please help on that? Sorry for my fresh question. Thank you very much for your help!

With Me.Form.RecordsetClone
    **.AbsolutePosition = Me.optChooseBase - 1**
    varSomeVariable = .Fields("contact_SFDC_code")
End With


DoCmd.OpenForm "Call Table", _
    WhereCondition:="[contact_SFDC_code] = " & varSomeVariable, _
    WindowMode:=acDialog, _
    OpenArgs:=(Me.[Search SFDC Code Form])

Sorry missed the error message. "Method or data member not found" — Sophia Wong

Gustav Gustav · Accepted Answer · 2018-02-23T09:20:47

All you need should be:

DoCmd.OpenForm "Call Table", _
WhereCondition:="[contact_SFDC_code] = " & Me!contact_SFDC_code.Value & "", _
WindowMode:=acDialog, _
OpenArgs:=Me![Search SFDC Code Form].Value

or, if code a string:

WhereCondition:="[contact_SFDC_code] = '" & Me!contact_SFDC_code.Value & "'", _

Access 2016 Subform select record to open other form

1 Answers