Control Source changing randomly

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Thanks Allen. That seems to have fixed the problem.

Allen Browne said:
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.

RBesdansky said:
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
Click to expand...
Click to expand...
 
Back
Top