using form field values in a query

  • Thread starter Thread starter Michael Bielski
  • Start date Start date
M

Michael Bielski

In developing an Access 2000 application for my employer,
part of the query I am trying to write has be pulled from
a hidden form. Specifically, two values, one from the
[session] field (which comes through fine) and one of the
fields (not the data) in the WHERE clause, dictated by
the value in the [location] field. Now, I can get the
query to run, but I consistently get a blank recordset
returned, and I know I have data in the table to match
what the query is supposed to be looking for. So... where
does this query go wrong?

SELECT [speaker-session].[Class Title], [speaker-
session].speaker, [Raw Data].*
FROM [speaker-session] INNER JOIN [Raw Data] ON [speaker-
session].session = [Raw Data].Session
WHERE ((([Forms]![comment data holder]![location])="1")
AND (([Raw Data].year)="2004") AND (([Raw Data].Session)=
[Forms]![comment data holder]![session]));

Any insight into why I get a blank recordset would be
helpful. My suspicion is that the value in [location]
somehow just isn't matching up with the column name, but
I can't see any way to prove it is or isn't. If I take
that part of the WHERE clause out, I get data returned
for all of the locations that the [location] field could
hold. Problem is, I need data for specific locations,
hence my perdicament.
 
You have the following requirements when

[speaker-session].session = [Raw Data].Session (The Inner Join)

1. [Forms]![comment data holder]![location])="1"
2. [Raw Data].year="2004"
3. [Raw Data].Session=[Forms]![comment data holder]![session]

If anyone of these is false, then your recordset will be empty. Double
check that these are all true
 
Back
Top