Related field Data Population Failed in Access 2003

[Guest]

I'm not Access programmer but got the task to fix some function after Access
upgrade from 97 to 2003.
FORM xyz contains the following
Function A:
name = ElementX,
source control = Company,
row source type = table/query
row source = qryGetCompanyList
(an existing query generates company list,
sql = select distinct companyName from company)
element type not Text Box nor List Box,
comment: the VBA code does not have a sub(routine) for this element name
status = working,

Function B:
name = ElementY
(supposed to display a list of products depending on Function A, which
company has been selected),
source control = Products,
(it is supposed to generate a list of products that the selected company
has, in other words, based on FUNCTION A's company selection),
element type not List Box nor Combo Box
comment: I don't VBA sub/routine for this element name
status = not working.

Before the upgrade both functions worked. Now, questions:
1) I open the db with Access 97, I still don't see the underlying query for
ElementY and yet, this function works with '97;
2) Say, I find out the second query, how do I reference the selected company
(value).

Many thanks in advance.

 

[David C. Holley]

Are you dealing with a FUNCTION problem or a problem related to a
CONTROL? There's a big difference between the two. A FUNCTION or SUB is
a block of code. A CONTROL is an element on a FORM or REPORT that
displays specific information (e.g. Current Date & Time). Typical
CONTROLS are TEXT BOX, COMBO BOX, LIST BOX, command buttons, etc.

 

[Guest]

Ahe, FUNCTION, here, was refered as an Element's function in a Form, but
according to Access's world, semantic-wise, it would be ELEMENT, and yes, we
were talking about elements in a form. Do you see what's going on?

Also, I notice that there are tons of macros there, none of them seem to
suggest relationship with the form elements merely by their names.

TIA

 

[Guest]

CONTROL.

Are you dealing with a FUNCTION problem or a problem related to a
CONTROL? There's a big difference between the two. A FUNCTION or SUB is
a block of code. A CONTROL is an element on a FORM or REPORT that
displays specific information (e.g. Current Date & Time). Typical
CONTROLS are TEXT BOX, COMBO BOX, LIST BOX, command buttons, etc.