When I do that I get the text entered isn't an item on the list and when I go to add it I get the linked table has been changed on the server, the last entry will not be saved. I do not want to add the entry to the list, rather save it to the individual record. Thanks.
I do not have access to the server in which the link was made so I do not want to break it.
I think I found a solution but it doesn't function as expected:
There is a textbox (Other) that if the word "Other" is selected from the Instituion combo-box is enabled for the user to type in, but if "Other" is not chosen then the Other Textbox is locked so the user can not type in it. The code below seems to enable the textbox all the time. Thanks.
Code:
Private Sub Institution_AfterUpdate()
If Institution = "Other" Then
Other.Locked = False
Other.Enabled = True
Else
Institution = "In-House" Or "Argentina" Or "Northwestern"
Other.Locked = True
Other.Enabled = False
End If
End Sub
