How check whether a form is bound to a recordset?
Posted on 2006-07-17
I have a form that I open, then bind a recordset to.
The form's On Current event fires when the form is first opened, before the recordset is bound, and trips an error, since the controls it examines are not yet populated.
How can I write a check to see whether there is a recordset present, to filter out these commands from On Current?
[NB it's possible that the error is due to something else, since only one of several lines in On Current triggers the error:
Me.SectionFinder.Value = Me.Controls("Type").Value
gives error 438: object doesn't support this property or method.]
Happy with an answer to either!