disabling fields

[Compufreak]

Hi everyone



i would like to know on which event would i need to put some code in order to display some functionality.


basically this is what i would like to do , if a person uses the search text box i would like my start date , end date text boxes and 3 other combo boxes to be disabled.

but should the user select a start date first , then i would only like for the search text box to be disabled.


i have managed to do the first option but it gets tricky as when the cursor loses focus on the text box my other fields do not enable.


please help

much appreciated

[alansidman]

First set the controls to disabled or not visible (your choice) with the on current event.
Then make the ones you want activated (visible or enabled) with the after update event for the start date.

[Compufreak]

this is what i have did to disable the other fields

Private Sub Search_Click()
If (Search.Text <> " ") Then
             Me.Search.Enabled = True
             Me.StartDate.Enabled = False
             Me.EndDate.Enabled = False
             Me.Combo1.Enabled = False
             Me.Combo53.Enabled = False
             Me.Combo72.Enabled = False
End If
End Sub

now i am trying to figure out how to enable the other fields should the search box lose its focus.

i have tried using the lost focus for the search box but it doesn't seem to be working

[sireesha]

try the above code in searchtextbox gotfocus
exrivate sub search_textbox_gotfocus()
me.search.enable=true

end sub
and
also like startdate_gotfocus
other controls enable false
i think its working. give me a reply

[Compufreak]

Hi sireesha

thanks for the reply

i shall try what you have told me to do... just one question...

wont the enable field be enabled and not enable lol

but thanks again appreciate it

[Rod]

Some thoughts: this is not as straightforward as it first seems. First consider the initial condition. If both the search text and the start date are null/empty then the user is given the choice of either control; in other words both controls must be enabled. If either one has a non null value then the controls must be disabled according to the rules. If both have values, what happens? (Note: the dates and other combo boxes may be considered as a set.)

Now consider the reaction as the user enters/selects values. I suggest using the before update event since controls are being disabled/enabled.

Before update of search text.
IF Trim(Nz(searchtext,"")) = "" THEN enable start date, etc. ELSE disable start date, etc.

Before update of start date
IF Trim(Nz(startdate, "")) = "" THEN enable search text ELSE disable search text.

The Trim(Nz( ... function may not be the best way of testing for an empty control value; use whatever is most appropriate.

[sireesha]

Hi sireesha

thanks for the reply

i shall try what you have told me to do... just one question...

wont the enable field be enabled and not enable lol

but thanks again appreciate it

Hi,

if searchtext box is enabled=false all other fields are enable=true
like startdate box is enabled=false all other fields are enable=true
these related code should write it for those textbox gotfocus.

[Rod]

My advice? Forget the GotFocus event!

[Compufreak]

rob is correct , trying your choice now rob