Open query based form with parameter

I have query based form:
Form1

Query:
SELECT Table1.*
FROM Table1
WHERE (((Table1.ID)=[openid]));



how to pass a parameter value for [openid], when i  open this form from another.
LVL 1
CMDAIAsked:
Who is Participating?
 
peter57rConnect With a Mentor Commented:
You can't do it that way.

If Openid is a field on the calling form then use:

WHERE Table1.ID=forms!callingformname!openid;
0
 
CMDAIAuthor Commented:
Yes i think this would be ieasier, i get carried away by imagination sometimes.
0
All Courses

From novice to tech pro — start learning today.