Everyone, I have to appologize If I have misrepresented facts. My initial note says everything on the RIGHT side of the = sign works, in other words, I have a value returned. My problem is Between the WHERE statement and the LEFT side of the = sign.

Looking at my original note I have identified below the problem areas.

.Open "SELECT Uparm, Aparm FROM WIST WHERE (Fields('Uparm').Value
= " & Me.Uparm & ")"


.Open SELECT Uparm, Aparm FROM WIST WHERE Problem Area = No Problem area

While I have not attempted the last suggestion as of yet, I wanted to say thanks now for your support.

StepD

Guys, to help someone else in the future, the answer is...

.Open "SELECT Uprm, Aprm FROM Wist WHERE Uprm = '" & Me.Uprm & "'"

Thanks for your willingness to help. It was the right side afterall.

StepD