MULTIPLE RECORDSET RETURN

[dk]

Hello all of You !
I need Your help.
I have table tblEvents and table tblClients.
Id like to create recordset which will return all events (multiple records)
from table tblEvents associated with Client name.


Set db = CurrentDb()
Set rst = db.OpenRecordset("tblEvents", dbOpenDynaset)
rst. "ClientName = '" & me.ClientName & "'"
rst.close

Thank You in advance
Regards,
DK

 

[James Goodman]

I cant remember much about DAO, but I think you would be better using a SQL
Statement:
Dim strSQL as String
strSQL = "SELECT * FROM tblEvents WHERE ClientName = '" & Me.ClientName &
"'"
Set rst = db.OpenRecordset(strSQL,dbOpenDynaset)
....

 

[dk]

Yes, You re right !
Thanks !
DK

I cant remember much about DAO, but I think you would be better using a SQL
Statement:
Dim strSQL as String
strSQL = "SELECT * FROM tblEvents WHERE ClientName = '" & Me.ClientName &
"'"
Set rst = db.OpenRecordset(strSQL,dbOpenDynaset)
...