list box names

[Zebble]

I'm working on a grant tracking app for a small non-profit. It's working
well, but I've come across an issue that really puzzles me. I have two list
boxes:

List2 (created via a wizard) calls a query to produce a list of grants.
Selection of a grant will display the underlying grant info (amount, term
date, etc.).

LFunderGrant (created also via a wizard, but renamed later) calls a table of
foundations and is linked to the grant query via a foundation ID.

As I said, everything works fine, as I have it: select a grant from List2,
the grant displays and the foundation is highlighted in LFunderGrant.

Since I like to have more meaningful list box names, if I try to rename
List2 to something like LGrants, I can still select the grant, but the
corresponding grant record does not display and the foundation list does not
change. If I change the name back to List2, it works again.

Does anyone have a clue as to why this is happening and what, if anything, I
can do to fix it? I'm running Access 2003 SP3.

Thanks,

 

[Mr. B]

Zebble,

When you renane a control that already has code behind it, the code is not
changed to reflect the new control name.

The easiest way to get this resolved is to again define the event for the
control after you have renamed it. Then just copy just the code from the
event that still exists for the previous name of the control to the new event
for the new name of the control. Then you can just delete the entire event
for the old name.

HTH

Mr. B
(askdoctoraccess dot com)