Access 2003 form criteria for inline list box query

[rhobson2]

Hello,
I wrote a database applicaiton using Access XP (2002) and everything
has been working good for the client until they purchased a couple of
new computers with Access 2003.

The meetings form has an unbound combo box listing all the meetings in
the database allowing the user to navigate between meeting records.

The meetings form also has a list box that displays a list of members
associated with a meeting.
The list box has an inline query that uses the navigation combo box as
the parameter for the list of meeting members shown. THe list box's
row source is
SELECT [FirstName] & " " & [LastName] FROM MembersTbl WHERE
MembersTbl.MeetingID = [Forms]![MeetingFrm]![MeetingNavigationComboBx]

The database has been and is working fine with Access 2000 and Access
XP (2002), however when used with Access 2003 the list box's inline
query is changed to:
SELECT [FirstName] & " " & [LastName] FROM MembersTbl WHERE
MembersTbl.MeetingID = [Forms]![Form]![MeetingNavigationComboBx]
Access then prompts for the query criteria because it cannot find
control.

I have checked all of my code and the only references that I make to
the list box are to requery the listing. The criteria seems to be
changed even before the form opens.

I can manually change the list box query, however it reverts back to
the incorrect criteria and I don't want the users to have to go in and
change the list box query each time they try to open the form.

I've searched Microsoft and Google groups but have not found anything
simular to this. I apologize in advance if I missed an obvious
posting.

Has anyone else encountered anything simular? or have any suggestions?

Thanks in advance

[Larry Linson]

Is the Form still named MeetingFrm? And, by "inline query", do you mean
RowSource? I do not know why your Query would be changed unless at some
point you changed the name of MeetingFrm to "Form" (and, because Form is a
reserved word, that wouldn't be a good idea) and had the NameAutoCorrect
feature ON (you may have seen strong recommendations to turn that OFF here
in the newsgroups, as well as the sarcastic references to NameAutoCorrupt).

Larry Linson
Microsoft Access MVP
<rh******@triad.rr.comwrote in message
news:11**********************@v33g2000cwv.googlegr oups.com...

Hello,
I wrote a database applicaiton using Access XP (2002) and everything
has been working good for the client until they purchased a couple of
new computers with Access 2003.

The meetings form has an unbound combo box listing all the meetings in
the database allowing the user to navigate between meeting records.

The meetings form also has a list box that displays a list of members
associated with a meeting.
The list box has an inline query that uses the navigation combo box as
the parameter for the list of meeting members shown. THe list box's
row source is
SELECT [FirstName] & " " & [LastName] FROM MembersTbl WHERE
MembersTbl.MeetingID = [Forms]![MeetingFrm]![MeetingNavigationComboBx]

The database has been and is working fine with Access 2000 and Access
XP (2002), however when used with Access 2003 the list box's inline
query is changed to:
SELECT [FirstName] & " " & [LastName] FROM MembersTbl WHERE
MembersTbl.MeetingID = [Forms]![Form]![MeetingNavigationComboBx]
Access then prompts for the query criteria because it cannot find
control.

I have checked all of my code and the only references that I make to
the list box are to requery the listing. The criteria seems to be
changed even before the form opens.

I can manually change the list box query, however it reverts back to
the incorrect criteria and I don't want the users to have to go in and
change the list box query each time they try to open the form.

I've searched Microsoft and Google groups but have not found anything
simular to this. I apologize in advance if I missed an obvious
posting.

Has anyone else encountered anything simular? or have any suggestions?

Thanks in advance

[rhobson2]

I have never renamed the form in question, it has always been
MeetingFrm.

By "inline query" i do mean the Rowsource for the list box. However,
the query is not saved as an actual object thus the "inline query"
reference. Sorry form making up a term that wasn't official.

I will check on the NameAutoCorrect feature. Is this option only in
Access 2003? Is this option a database file specific option or a
machine specific option?

Thanks.
Larry Linson wrote:

Is the Form still named MeetingFrm? And, by "inline query", do you mean
RowSource? I do not know why your Query would be changed unless at some
point you changed the name of MeetingFrm to "Form" (and, because Form is a
reserved word, that wouldn't be a good idea) and had the NameAutoCorrect
feature ON (you may have seen strong recommendations to turn that OFF here
in the newsgroups, as well as the sarcastic references to NameAutoCorrupt).

Larry Linson
Microsoft Access MVP
<rh******@triad.rr.comwrote in message
news:11**********************@v33g2000cwv.googlegr oups.com...

Hello,
I wrote a database applicaiton using Access XP (2002) and everything
has been working good for the client until they purchased a couple of
new computers with Access 2003.

The meetings form has an unbound combo box listing all the meetings in
the database allowing the user to navigate between meeting records.

The meetings form also has a list box that displays a list of members
associated with a meeting.
The list box has an inline query that uses the navigation combo box as
the parameter for the list of meeting members shown. THe list box's
row source is
SELECT [FirstName] & " " & [LastName] FROM MembersTbl WHERE
MembersTbl.MeetingID = [Forms]![MeetingFrm]![MeetingNavigationComboBx]

The database has been and is working fine with Access 2000 and Access
XP (2002), however when used with Access 2003 the list box's inline
query is changed to:
SELECT [FirstName] & " " & [LastName] FROM MembersTbl WHERE
MembersTbl.MeetingID = [Forms]![Form]![MeetingNavigationComboBx]
Access then prompts for the query criteria because it cannot find
control.

I have checked all of my code and the only references that I make to
the list box are to requery the listing. The criteria seems to be
changed even before the form opens.

I can manually change the list box query, however it reverts back to
the incorrect criteria and I don't want the users to have to go in and
change the list box query each time they try to open the form.

I've searched Microsoft and Google groups but have not found anything
simular to this. I apologize in advance if I missed an obvious
posting.

Has anyone else encountered anything simular? or have any suggestions?

Thanks in advance

[Larry Linson]

<rh******@triad.rr.comwrote

I have never renamed the form in question,
it has always been MeetingFrm.

I asked because it appeared that "MeetingFrm" in the SQL had been changed to
"Form". Did you try manually changing it back to "MeetingFrm"? If so, what
was the result? If not, give it a try... of course, before "dinking around
with" your database, you should always make a backup copy.

I will check on the NameAutoCorrect feature.
Is this option only in Access 2003? Is this option
a database file specific option or a machine
specific option?

No, it applies to some earlier versions as well... note it is not the
"AutoCorrect Options" directly on the Tools menu, but Tools | Options |
General | Track Name AutoCorrect.

Most of the experienced posters here suggest you turn it off, because it can
occasionally have some unanticipated consequences.

It appears to be an Access-wide setting on a machine, but is probably also
user-specific if you have more than one Userid. Of course, if there's a
userid that both you and I use, then each of us will have the same username
for user-specific items.

Larry Linson
Microsoft Access MVP