Frustration springs eternal
I am having trouble with opening a query and recordset in code. This is
code associated with a form, and I basically am setting values based upon a
query. The query would be filtered or a parameter query depending on how
you come at it I guess.
the parameter is on the form, called txtClientID. I have created a
parameter query called qryClienDOPara. this query has a criterion of
"Forms!frmClientBasic!txtClientID"
The very first line of the below code gives me the following error:
"Object variable or with block not set". ClientDO has been dimmed as a
query definition.
Set ClientDO = db.QueryDefs("qryClientDOPara")
Set rsClientDO = ClientDO.OpenRecordset(dbOpenSnapshot)
