J
Jon Dragt
I have a combo box with the row source query of:
"SELECT DISTINCT [Zip Codes].ZIP FROM [Zip Codes] WHERE
((([Zip Codes].City)=Forms!Contacts!Individuals!City) And
(([Zip Codes].ST)=Forms!Contacts!Individuals!State)); "
In the On Enter event I have it do a requery to feed the
combo box with new values based what the user entered in
the city and state fields. This works fine in Access 2002
but no longer works in 2003. In testing this I created a
separate query with the form open and it seemed that the
Forms!Contacts!Individuals!City and !State fields don't
have values (as far as the query is concerned. I do the
exact same thing under 2002 and the [Forms]![Contacts]!
[Individuals]![City] and !State fields show values in the
query.
Can anybody tell me why this is happening and how to work
around it?
Cheers,
Jon
"SELECT DISTINCT [Zip Codes].ZIP FROM [Zip Codes] WHERE
((([Zip Codes].City)=Forms!Contacts!Individuals!City) And
(([Zip Codes].ST)=Forms!Contacts!Individuals!State)); "
In the On Enter event I have it do a requery to feed the
combo box with new values based what the user entered in
the city and state fields. This works fine in Access 2002
but no longer works in 2003. In testing this I created a
separate query with the form open and it seemed that the
Forms!Contacts!Individuals!City and !State fields don't
have values (as far as the query is concerned. I do the
exact same thing under 2002 and the [Forms]![Contacts]!
[Individuals]![City] and !State fields show values in the
query.
Can anybody tell me why this is happening and how to work
around it?
Cheers,
Jon