Opening a recordset

[kiashi]

Fixed

Okay, crisis over.

I realised that my problem was actually the fact that my query was referencing a form field in the way Forms!frmHDSearch!txtNum and have since discovered that this does not work in the code.

So I have conceded defeat and created another query that accepts a parameter and have populated this from the txtNum form field within the code itself. All is now well.

I must credit this page with enlightening me:
http://www.mvps.org/access/queries/qry0013.htm

Thanks anyway,
Kiashi