I have run into a extremely nerving problem with a Data Control (the VB
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."