I have run into a extremely nerving problem with a Data Control (the VB built-in one):

in some installations of our software the Reposition event does not fire (see code outline below). When this happens, testing CustomerData.Recordset for Nothing returns True EVEN THOUGH it has explicitly been set in the preceding line.

- Has anyone experienced a similar problem?
- Does anyone know how to fix this?
- Does anyone know of a workaround? I tried calling the event routine directly, but obviously this was in vain because CustomerData.Recordset is not set by the explicit assignment.

Private Sub cmdFind_Click()
  dim rs as DAO.Recordset
  set rs = db.OpenRecordset(....)
  ' this normally fires CustomerData_Reposition
  set CustomerData.Recordset = rs
  debug.print "rs is " & Iif(rs is nothing,"not ","") & "set."
  ' in the case where the Reposition event does not fire,
  ' the following line prints '... not set.'
  debug.print "CustomerData.Recordset is " _
     & Iif(CustomerData.Recordset is nothing,"not ","") & "set."
End Sub

Try to use NEW operator in the following definition

dim rs as NEW DAO.Recordset

yes - but still no Reposition event

it is not the rs recordset that is Nothing, just the CustomerData.Recordset property

Georg