Solved

Open query based form with parameter

Posted on 2008-10-19
2
743 Views
Last Modified: 2008-10-20
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.
0
Comment
Question by:CMDAI
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 200 total points
ID: 22755688
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
 
LVL 1

Author Comment

by:CMDAI
ID: 22756075
Yes i think this would be ieasier, i get carried away by imagination sometimes.
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question