Novice Field Referencing Problem
James Fortune
for about three weeks now. The situation is I have a form with several
combo boxes on it that I would like to use to supply criteria for a
query. A command button on the form opens the query. The query
pulls data from two linked tables. If I leave the criteria boxes blank
the query runs fine and pulls in all the data. When I use the expression
builder to refer to the combo box values the query comes up BLANK. The
combo box values come from separate tables. I would appreciate any
advice emailed to me or posted here.
Thanks in advance,
JAF
--
James Fortune - This sig file has been modified. It has
Oakland University - been reformatted to fit your screen.
jafo...@vela.acs.oakland.edu -
Disclaimer: Not O.U. opinions -
Ben Tallman
>From: jafo...@vela.acs.oakland.edu (James Fortune)
>Subject: Novice Field Referencing Problem
>Date: 15 Dec 1994 15:06:11 GMT
>Summary: Can someone explain this behavior?
>Keywords: Combo Box, Query, Criteria
>I read the Access manual (quickly) and have been programming in Access 2.0
>for about three weeks now. The situation is I have a form with several
>combo boxes on it that I would like to use to supply criteria for a
>query. A command button on the form opens the query. The query
>pulls data from two linked tables. If I leave the criteria boxes blank
>the query runs fine and pulls in all the data. When I use the expression
>builder to refer to the combo box values the query comes up BLANK. The
>combo box values come from separate tables. I would appreciate any
>advice emailed to me or posted here.
I ran into this at a client site the other day, and it looks to me like it is
a problem, either with the windows install or with the Access install, because
the same program runs perfectly on several other machines, from a pentium to a
DX/33. On Monday I go back armed with the info that the app works on other
computers, just not on that system, and try to solve the problem.
If you figure it out, post it!
Ben Tallman