Control Source changing randomly

[Guest]

I have a listbox whose RowSource includes a reference to a "MemberID" control
on the same form. I have another form based on the same table as the first
form. The second form also has a control called MemberID. I find that the
reference to the MemberID control in the list box's row source is changed by
Access to the name of the MemberID control on the other form. So, without me
doing anything, the list box criteria changes from

[Forms]![frmMemberMain]![MemberID]

to

[Forms]![frmMemberDemographics]![MemberID]

Has anybody else had this problem?
Thanks

 

[Allen Browne]

If it really did change like that, you might like to turn off the Name
AutoCorrect property.

In Access 2000, 2002, and 2003, its:
Tools | Options | General | Name AutoCorrect
In Access 2007, it's:
Office Button | Access Options | Current Database | Name AutoCorrect

Explanation of why:
http://allenbrowne.com/bug-03.html

 

[Guest]

Thanks Allen. That seems to have fixed the problem.

If it really did change like that, you might like to turn off the Name
AutoCorrect property.

In Access 2000, 2002, and 2003, its:
Tools | Options | General | Name AutoCorrect
In Access 2007, it's:
Office Button | Access Options | Current Database | Name AutoCorrect

Explanation of why:
http://allenbrowne.com/bug-03.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have a listbox whose RowSource includes a reference to a "MemberID"
control
on the same form. I have another form based on the same table as the first
form. The second form also has a control called MemberID. I find that the
reference to the MemberID control in the list box's row source is changed
by
Access to the name of the MemberID control on the other form. So, without
me
doing anything, the list box criteria changes from

[Forms]![frmMemberMain]![MemberID]

to

[Forms]![frmMemberDemographics]![MemberID]

Has anybody else had this problem?
Thanks