AutoHotkey Homepage AutoHotkey Community
Let's help each other out
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Access Question - How Do I Refer to Control on Current Form

 
Post new topic   Reply to topic    AutoHotkey Community Forum Index -> General Chat
View previous topic :: View next topic  
Author Message
Rhys



Joined: 17 Apr 2007
Posts: 710
Location: Florida

PostPosted: Wed Jan 30, 2008 9:01 pm    Post subject: Access Question - How Do I Refer to Control on Current Form Reply with quote

I'm using the following criteria on the data source for a control on a form so I can only choose contacts from the location I select in the previous control:
[forms].[frm_ticket_tracking_v2].[field_Location]

I want to have multiple versions of this form, so would have to specify the exact name in that query to match the name of the form's version... I know there's a way to do this with something like:
[me].[field_location] or [forms].[me].[field_location]

But I am having no luck, and Google searches aren't helping too much... Anyone know what the syntax is?
_________________
[Join IRC!]
Back to top
View user's profile Send private message
Dragonscloud



Joined: 16 Jul 2005
Posts: 96

PostPosted: Wed Jan 30, 2008 11:34 pm    Post subject: Reply with quote

Here's one way to do it in VBA:

strCriteria = "[SomeFieldFromATable]=" & "'" & Me![txtMyTextbox] & "'"
_________________
“yields falsehood when preceded by its quotation” yields falsehood when preceded by its quotation.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    AutoHotkey Community Forum Index -> General Chat All times are GMT
Page 1 of 1

 
Jump to:  
You can post new topics in this forum
You can reply to topics in this forum


Powered by phpBB © 2001, 2005 phpBB Group