Hi All
I am trying to open the form for a specific record. The following code works fine:
But why the following isn't working?????
And also I tried to open another form using below and it worked so just wondering why I am not able to open FrmABC using the below code:
Thanks
I am trying to open the form for a specific record. The following code works fine:
Code:
sForm = "frmABC"
sSQL = "[AuditID]=" & Me![lstSearch]
DoCmd.OpenForm sForm
DoCmd.OpenForm sForm, , , sSQL
But why the following isn't working?????
Code:
DoCmd.OpenForm "frmABC", , , "[AuditID] =" & Me.lstSearch
And also I tried to open another form using below and it worked so just wondering why I am not able to open FrmABC using the below code:
Code:
DoCmd.OpenForm "frmABC", , , "[AuditID] =" & Me.lstSearch
Thanks