I have the following code:
Me.OrderBy = "person_id"
Me.OrderByOn = True
where person_id is the form field's control source. However, I wish to use its name instead. Is there a way to do this.
So, for clarity, in the form design, the field on the form has a control source of "person_id" (from the "data" tab), but its name is "field_1" (from the "other" tab).