- Local time
- Today, 12:45
- Joined
- Feb 19, 2002
- Messages
- 43,275
Change the parameters in the query. Instead of referencing a form field use a parameter. Therefore
qd.Parameters![Forms]![frmACPData]![UnitNo] = UnitNo
qd.Parameters![Forms]![frmACPData]![EpisodeID] = EpisodeID
becomes:
qd.Parameters![Unit No] = [Forms]![frmACPData]![UnitNo]
qd.Parameters![Episode ID] = [Forms]![frmACPData]![EpisodeID]
But what is the point of opening a recordset and not doing anyghing with it?
qd.Parameters![Forms]![frmACPData]![UnitNo] = UnitNo
qd.Parameters![Forms]![frmACPData]![EpisodeID] = EpisodeID
becomes:
qd.Parameters![Unit No] = [Forms]![frmACPData]![UnitNo]
qd.Parameters![Episode ID] = [Forms]![frmACPData]![EpisodeID]
But what is the point of opening a recordset and not doing anyghing with it?