I have a query that I'm using to identify audit questions as determined by a
combo I want this query to return audit questions based on a value in a combo
box on a form.  I also want to add a field to the query that will populate
with PrimaryID field on that same form.

For example, Let's say I have the PreAudit form open to Audit1 (PrimaryID =
1), and it is an audit type 2 (TypeNum = 2).  I want to return all questions
in the questions table where the TypeNum is 2 and I want to add a field to
the end that returns the value in PrimaryID on the PreAudit form.

I should see this:
TypeNum | QuestionText | Points | AuditID
           2 | Phone           |        3 |         1

Instead of getting 1 in the AuditID field, I get a square or a letter or
some random number, even though the form is open and the field displays 1.

Here is what I have in the QBE grid:
AuditID: [Forms]![PREAUDIT]![PRIMARYID]

ADDED:
Here is the SQL:
SELECT Questions.TypeNum, Questions.GroupNum, Questions.SubGroupNum,
Questions.QuestionNum, Questions.Type, Questions.Group, Questions.SubGroup,
Questions.Question, Questions.Points, [Forms]![PREAUDIT]![PRIMARYID] AS
AuditID
FROM Questions
WHERE (((Questions.TypeNum)=[Forms]![PREAUDIT]![PRIMARYID]) AND
((Questions.StartDate)<Now()) AND ((Questions.EndDate)>Now()));

This is from a database I created about a year ago and it worked just fine
then, but now it is failing.  It was created in AccessXP (same as I'm using
now).  I've tried running a database repair and even creating the database
from scratch.  Why won't this work???

robert_l_ross@hotmail.com.nospamplease

THX!