Hi,
I don't know where is the issue but I am having issue to display the result in my subform using the following query:
Can anyone help on it?
The SQL string shows:
but the subform does not display any data.
Thanks
I don't know where is the issue but I am having issue to display the result in my subform using the following query:
Can anyone help on it?
Code:
Dim strWhere As String
Dim rsResult As Recordset
strWhere = "SELECT * FROM tblWork WHERE client_id = " & Nz(Me.cboClient.Value)
Set rsResult = CurrentDb.OpenRecordset(strWhere, dbOpenSnapshot)
Me.frmWork.SourceObject = "sfWork"
Set Me.frmWork.Form.Recordset = rsResult
The SQL string shows:
Code:
SELECT * FROM tblWork WHERE client_id = "1A1"
but the subform does not display any data.
Thanks