Look up combo box activates other Text boxes

[oscar]

I am a novice and would like to create a form that
contains a text box control that is activated when "Other"
is selected from a look up combo box control. The "Other"
text box would update the source table for the look up
combo box and at the same time update the table that the
form is pointing to.

 

[Michel Walsh]

Hi,


For the first part of your question, you can add code in the after
update event of the combo box:



If "Other" = Me.ComboBoxnameHere.Value Then
Me.TextBoxnameHere.Visible=True
Else
Me.TextBoxnameHere.Visible=False
End if


Sure, you can also simplify it to just:

Me.TextBoxnameHere.Visible = CBool("Other"=Me.ComboBoxnameHere.Value)

Instead of playing with Visible, you can also play with Enabled ( or
Locked ).

I really don't understand the second part of your message.



Hoping it may help,
Vanderghast, Access MVP