Form Problems With XP- PLEASE HELP!

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

I am having a problem with a couple of forms in Office XP.

I have a form, and on that form is a datasheet subform.
The recordset of the datasheet subform is a temp table.
The parent form has code on it that adds records to the
temp table, and then requeries the subform.

The problem is, the subform does not display the data. If
I copy the SQL statement of the subform and paste it into
a query and run it, I get the records that are supposed
to be in the subform.

Also, any code that tries to access the subform using the
RecordsetClone property, gives a runtime error of:

Runtime Error '7591':
You entered an expression that has an invalid reference
to the RecordsetClone property

This situation is very confusing because it works in
Office 2000 just fine. Please help!

-Jim
 
Yes, the references are ok... I figured out what exactly
is causing the problem, however I have no idea how to fix
it.

The problem happens when I have a subform with a Record
Source that consists of a temp table with an inner join on
another table with pre-existing data.

I then have code on the parent form that creates a record
in the temp table. Despite the fact that I requery the
form, the record Source of the form becomes invalid and
causes all sorts of havock.

My best guess is that it is a timing issue in access...

Does anyone have any other ideas or suggestions on how to
get by this? The problem just came up in an entirely
different section of the program and is happening in the
2000 version. :(

Sigh

-Jim
 
Back
Top