Bug With Rowsource Property on Listboxes and Comboboxes?

[CrazyAccessProgrammer]

Im using Access 2007 (fully patched/updated as of today 02/05/2009)

Whenever I edit the rowsource property of a listbox or combobox the changes
are NOT saved to the form... even when I explicitly click the save button.

I click on the ... button in the rowsource property, enter the query
designer, make my changes, close the query designer, click YES when it
prompts me to save my changes, the click the save button to save the form,
then close the form. When I come back my rowsource property's state is what
it was before the changes I had just tried to make.

What I've been doing to work around this issue is after editing the
rowsource property, Ill change something else on the form (anything works)
and then save my form and my changes to the rowsource property will then take.

This is a pain though because I often forget to do the workaround then come
back later to realize my rowsource property for a listbox or combobox isn't
what I had tried to make it as and it's frustrating to keep having to go back
and fix this.

Is this a known issue?

 

[Linq Adams via AccessMonster.com]

From Allen Browne's article on 2007 bugs:

"If the source for a form/report is a SQL statement, and you click the Build
button beside the RecordSource property, your changes are lost when you
return from the query designer (unless you move to another property.)"

I'm guessing that you've found a variation of this, with the Row Source of
combo/list boxes being involved, instead of the Record Source of
forms/reports. This guess is bolstered by the fact that the same action,
moving to another property, appears to be the workaround. According to
Allen's site, this hasn't been addressed by Microsoft as of yet.

 

[CrazyAccessProgrammer]

Thank you very much. Thought I was just going crazy there...

And thanks for letting me know all i have to do is tab to a different
property before saving/closing the form versus changing a property that helps
speed things along.