Subform Recordsource

[James Franklin]

Hi,

Can anyone tell me if this is a known bug in Access 2003?

I have an unbound main form with an unbound list control and a subform. The
list box has a default value and the subform form has a SQL string as its
recordsource. The listbox AfterUpdate event changes the subform recordsource
string, depending on the listbox value selected.

When I first open my main form after saving my subform, everything is fine.
But if I make a change using the listbox to display different records/fields
in my subform, the new recordset is displayed even after I have closed and
re-opened my main form.

The weird thing is that my subform form settings seem to remain fine. If I
open the subform on its own, I get the correct, original recordset. But if I
open the main form, the subform results are different (there is no code in
the main form which manipulates the subform.)

As always, any help is greatly appreciated!

Cheers,
Jim

 

[James Franklin]

As an addumdum, to save anyone posting this suggestion, I have got a
workaround for this in that I have used the Open event of the subform form
to set the recordsource each time the form opens. But this just seems a bit
crazy when I am setting it to the same value as is already held in the
RecordSource property!

This is a pain, so I would love to know why it is happening,

Many thanks,
Jim