Making Text field active

[Tansar]

Hi,
Is it possible to make a text box field active based on content from another box?

Basically I have a drop dwon combo box that shows a list, such as 'active, withheld, archived, etc'. If the used selects archived, then I'd like the the textbox to be active so the user can input a date that it was archived.

Hope that makes sense

TIA

 

[rainman89]

sure in the after update event of the combo you can check to see if its value is whatever you want then base that on if you make your textbox active or not.

so

if me.combo = "whatever" <- you could also base this on the index or whatever value your combo is based on
then
me.yourtextboxname.active="true"
else
'do nothing
end if

 

[khawar]

in the after update event field of combo write the code below

if me.combo(your combo Name Here) = "Archived" then
textbox1(your Text box Name Here).enabled=true
else
textbox1(your Text box Name Here).enabled=false
endif

 

[Tansar]

Thank you for the prompt response...

My combo box is called: St_Status
My text box is called: archive - which is unbound.

Do I use the 'Expression builder' to write that code.

This is all new to me

Thanks again.

 

[Tansar]

Is the following correct?

Private Sub ST_Status_AfterUpdate()
If Me.combo(ST_Status) = "Archived" Then
archive(archive).Enabled = True
Else
archive(archive).Enabled = False
End If

End Sub

 

[rainman89]

Private Sub ST_Status_AfterUpdate()
If Me.ST_Status = "Archived" Then
me.archive.Enabled = True
Else
me.archive.Enabled = False
End If

End Sub

 

[Tansar]

Cool!!
Thank you