UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Defining "Query" on form load    
 
   
choli0090
post Jul 31 2008, 02:11 AM
Post #1

UtterAccess Addict
Posts: 120
From: WA State
Hello Everyone,

I am trying to see if I create a database without any Macros & any defined queries (shown in the query tab). So far I have been able to succeed except that I have a few pivots based upon some of the queries.

What I am seeing & asking how to do is, is there a way to define the query in code when the form opens. so the pivot references the code instead of the actual query.

Thanks!!
Go to the top of the page
 
+
Steve Schapel
post Jul 31 2008, 03:00 AM
Post #2

UtterAccess VIP
Posts: 3,881
From: New Zealand
Chris,

The Open event is better than the Load event.

Something like this, if I understand you correctly...

Me.RecordSource = "SELECT ... "
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 23rd May 2013 - 03:00 AM