I'm using
Code:
DLookUp("Model_Name","tblModels","Model_ID = " & [Model_ID])
in my data field of a textbox. I have also made a button for each of the columns to sort by.
Code:
Private Sub btnFilterModel_Click()
If Me.OrderBy = "[Model_ID]" Then
Me.OrderBy = "[Model_ID] DESC"
Else
Me.OrderBy = "[Model_ID]"
Me.OrderByOn = True
End If
End Sub
Now, obviously it filters based on the ID number. Is it possible for access to look at what the value the ID represents and sort from the word instead of the number?