| View previous topic :: View next topic |
| Author |
Message |
Rhys
Joined: 17 Apr 2007 Posts: 710 Location: Florida
|
Posted: Wed Jan 30, 2008 9:01 pm Post subject: Access Question - How Do I Refer to Control on Current Form |
|
|
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 |
|
 |
Dragonscloud
Joined: 16 Jul 2005 Posts: 96
|
Posted: Wed Jan 30, 2008 11:34 pm Post subject: |
|
|
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 |
|
 |
|