combo-box free text

[awake2424]

I posted this on the modules and VBA but it may be better suited here:

How do I allow a user the ability to enter in text into a combo-box so that it saves to that record? Thanks.

 

[vbaInet]

I posted this on the modules and VBA but it may be better suited here:

Here's the thread:
http://www.access-programmers.co.uk/forums/showthread.php?t=267643

You could have deleted the other post if you felt it would be best suited here.

Perhaps Uncle T can merge?

 

[awake2424]

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.

 

[awake2424]

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.

 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