Subform Recordsource

  • Thread starter Thread starter James Franklin
  • Start date Start date
J

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
 
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
 
Back
Top