title: how to read one field from one record
body: <p>I know I'm over thinking this, but I want to check a single value/field within a single record. For instance, I want to know if the value of the "closedDate" field in the record with the primary key of 33 is null or not.</p>
  
  <p>I was thinking something like:</p>
  
  <pre><code>dim db as DAO.Database
  dim rs as DAO.Recordset
  set db = CurrentDb
  set rs = db.OpenRecordset("record_holdData")
  
  If not isNull(rs.Fields("closedDate")) then
       'do nothing
  Else
       'add a close date
  End If
  </code></pre>
  
  <p>But I don't think this is right. It doesn't specify the record number. In the application, the form is opened by being bound to the record in question, but I don't think <code>CurrentDb</code> takes that into consideration and rather references the entire table.</p>
  
  <p>So my question is, how do open the recordset in this fashion and reference this field in that particular record only?</p>