data control's recordset invalid after new form launch

data control's recordset invalid after new form launch

Post by Jeff Partridg » Thu, 09 Dec 1999 04:00:00

I'm working on a project that contains many data controls with bound
fields on the form.  When the user chooses to to get more information on
a specific field (ie customer), a new new form with it's data controls
is opened.  The problem I'm experiencing is a what appears to be a loss
of usability of the first form data control, because after the new form
closes, I try to update the original data and get Error 3420 (Object
Invalid or  No Longer Set).  I'm using transactions, so I've tried to
.Commit before launching the new form, but this didn't help.  I've tried
both Modal and Modeless, but the result is still the same.  I've even
tried to re-establish the Data control connection and recordsource, but
it still acts like the control is disabled or out of scope when I try to
access the recordset.

I've checked the recordset before opening the new window, and it has one
record.  I checked it again as soon as the other form closes (which is
NOT referencing the same table), and VB reports that the object is no
longer set or valid.
Is this a bug?

I appreciate any insight into this problem.



1. Launching new bound form from MDI form troubles

I am trying to tie a MDI form bound to a database to another MDI form which is
bound to the same database.  I have a tabbed dialogue box open which acts as a
container for a DB Grid control in which my records are displayed.  I want the
entire row (record) to hi-lite when the mouse is clicked anywhere in that row
and I want to be able to click my "EDIT" button and bring up the hi-lited
record in my second MDI form for editing.  This second form is already complete
and bound to the appropriate database.  I can do the "Add New" function but I
can't seem to find a way to do an "Edit", directly to the hi-lited record.


2. Help needed limiting recordsets

3. data control won't accept recordset from secured database

4. Invalid object name 'TableName'

5. Accessing the Data Control's Recordset

6. VB3 App. With SQLSERVER7

7. Data control won't accept DAO recordset!

8. Random order

9. Setting a recordset object to a data control's recordsource property

10. pass the value from my VB form to Data Report's label control

11. Using another form's Data control

12. Control missing from Form's controls collection