Jim-
When you use a reference like [Forms]![MyForm]![SomeControl], you are asking Access to go to the Forms collection (all open forms), find the form named "MyForm", then use the value in the control named "SomeControl". There is no such thing as a Queries collection, so your reference dies with the very first part.
What is it you're trying to do? Reference a value in another open query? Perhaps bind the query to a Form, then use the [Forms] syntax.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jul 31, 2014, at 3:21 PM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Hello,
I am trying to use a reference from a query like a Form reference. But what I am using is not working. I am getting a prompt for Queries. Is there something missing.
Thank You
=[Queries]![qryMaxCompensatory].[Supervisor] & "" & "Supervisor"
Jim Wagner
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar