Combo/Field Problem

[Dave]

Hi,

I have a combo box (Named: Ethnicity) and a field (Named:
OtherEthnicity) . From the combo drop down list when Other is selected, I
want the field next to it to be enabled when the selection is made.

I had a ago constructing some amateurish coding, but it does not work.

Private Sub Ethnicity_After Update()
If Other Then
[OtherEthinicity].Enabled = True
Else
[OtherEthinicity].Enabled = False
End If
End Sub

[pietlinden]

why not just set the LimitToList property of the Combobox to False and
then enter whatever you want?

[Dave]

There is a combo box on the form and another text box besides it, I want the
other text box to be activated when a certain selction has been made in this
case it is Other from the combo box. Setting the limit to list to false does
what to the other text box? Nothing!

<pi********@hot mail.com> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.com.. .

why not just set the LimitToList property of the Combobox to False and
then enter whatever you want?

[Tim Marshall]

Dave wrote:

Hi,

I have a combo box (Named: Ethnicity) and a field (Named:
OtherEthnicity) . From the combo drop down list when Other is selected, I
want the field next to it to be enabled when the selection is made.

I had a ago constructing some amateurish coding, but it does not work.

Try this:

Private Sub Ethnicity_After Update()
If me.Ethnicity = "Other" Then
Me.OtherEthinic ity.Enabled = True
Else
Me.OtherEthinic ity.Enabled = False
End If
End Sub

I personally prefer to follow a naming convention. I would name
Ethnicity as cboEthnicity and OtherEthinicity as txtOtherEthinic ity.

Have a read of this article on the Access web:
http://www.mvps.org/access/general/gen0012.htm

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

[Dave]

Thank You, Tim works perfectly, I will follow your naming methods too,
cheers.

"Tim Marshall" <TI****@PurpleP andaChasers.Moe rtherium> wrote in message
news:d0******** **@coranto.ucs. mun.ca...

Dave wrote:

Hi,

I have a combo box (Named: Ethnicity) and a field (Named:
OtherEthnicity) . From the combo drop down list when Other is selected, I
want the field next to it to be enabled when the selection is made.

I had a ago constructing some amateurish coding, but it does not work.

Try this:

Private Sub Ethnicity_After Update()
If me.Ethnicity = "Other" Then
Me.OtherEthinic ity.Enabled = True
Else
Me.OtherEthinic ity.Enabled = False
End If
End Sub

I personally prefer to follow a naming convention. I would name Ethnicity
as cboEthnicity and OtherEthinicity as txtOtherEthinic ity.

Have a read of this article on the Access web:
http://www.mvps.org/access/general/gen0012.htm

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

[Dave]

Doesn't seem to work with a tick box and a text box (txtDate) though, with
the coding:

Private Sub Check_AfterUpda te()
If Me.Check = "Yes" Then
Me.txtDate.Enab led = True
Else
Me.txtDate.Enab led = False
End If
End Sub

Tried changing the Yes to True but still no luck, any ideas?

"Tim Marshall" <TI****@PurpleP andaChasers.Moe rtherium> wrote in message
news:d0******** **@coranto.ucs. mun.ca...

Dave wrote:

Hi,

I have a combo box (Named: Ethnicity) and a field (Named:
OtherEthnicity) . From the combo drop down list when Other is selected, I
want the field next to it to be enabled when the selection is made.

I had a ago constructing some amateurish coding, but it does not work.

Try this:

Private Sub Ethnicity_After Update()
If me.Ethnicity = "Other" Then
Me.OtherEthinic ity.Enabled = True
Else
Me.OtherEthinic ity.Enabled = False
End If
End Sub

I personally prefer to follow a naming convention. I would name Ethnicity
as cboEthnicity and OtherEthinicity as txtOtherEthinic ity.

Have a read of this article on the Access web:
http://www.mvps.org/access/general/gen0012.htm

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

[pietlinden]

Dave wrote:

There is a combo box on the form and another text box besides it, I want the other text box to be activated when a certain selction has been made in this case it is Other from the combo box. Setting the limit to list to false does what to the other text box? Nothing!

<pi********@hot mail.com> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.com.. .

why not just set the LimitToList property of the Combobox to False and then enter whatever you want?

jeez, no need to get your knickers in a twist. What I was implying,
jackass, was that you did not really NEED the textbox at all, because
setting the LimitToList=Fal se on the combobox allows the user to enter
any value he wants.

[Dave]

Thats fine but it didn't answer the original question.

<pi********@hot mail.com> wrote in message
news:11******** *************@o 13g2000cwo.goog legroups.com...

Dave wrote:

There is a combo box on the form and another text box besides it, I

want the

other text box to be activated when a certain selction has been made

in this

case it is Other from the combo box. Setting the limit to list to

false does

what to the other text box? Nothing!

<pi********@hot mail.com> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.com.. .

> why not just set the LimitToList property of the Combobox to False and > then enter whatever you want?
>

jeez, no need to get your knickers in a twist. What I was implying,
jackass, was that you did not really NEED the textbox at all, because
setting the LimitToList=Fal se on the combobox allows the user to enter
any value he wants.

[Bob Quintal]

"Dave" <no************ *@my.email.is.i nvalid> wrote in
news:Bk******** *******@newsfe1-gui.ntli.net:

Thats fine but it didn't answer the original question.
That's because it's the wrong question. Certain functionality is
built into certain tools, with good reason. You should not go off
and do something different, without your understanding of how the
tools work, and how other applications use the same tools.

Piet was pointing out to you that the correct way of treating the
problem is not the way you intend to do it.

<pi********@hot mail.com> wrote in message
news:11******** *************@o 13g2000cwo.goog legroups.com...

Dave wrote:

There is a combo box on the form and another text box
besides it, I

want the

other text box to be activated when a certain selction has
been made

in this

case it is Other from the combo box. Setting the limit to
list to

false does

what to the other text box? Nothing!

<pi********@hot mail.com> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.com.. .
> why not just set the LimitToList property of the Combobox
> to False

and

> then enter whatever you want?
>

jeez, no need to get your knickers in a twist. What I was
implying, jackass, was that you did not really NEED the
textbox at all, because setting the LimitToList=Fal se on the
combobox allows the user to enter any value he wants.

--
Bob Quintal

PA is y I've altered my email address.

[Dave]

I'm not disagreeing it is maybe a better way. I'm currently learning by
using different methods for certain functions in my database, not using a
limit to list was one of the functions I don't want to use unfortunately
Bob/Piet, as the user does not want to type into a combo box.
I'm not sure what you meant by the statement 'You should not go off and do
something different, without your understanding of how the tools work' you
would never learn anything if you followed that rule. What makes things
exciting is trying different methods out, you learn about it as you go
along! ;-)

"Bob Quintal" <rq******@sPAmp atico.ca> wrote in message
news:1110411523 .6fd3230db2147e fd47f8a375d6ffc f4d@teranews...

"Dave" <no************ *@my.email.is.i nvalid> wrote in
news:Bk******** *******@newsfe1-gui.ntli.net:

Thats fine but it didn't answer the original question.

That's because it's the wrong question. Certain functionality is
built into certain tools, with good reason. You should not go off
and do something different, without your understanding of how the
tools work, and how other applications use the same tools.

Piet was pointing out to you that the correct way of treating the
problem is not the way you intend to do it.

<pi********@hot mail.com> wrote in message
news:11******** *************@o 13g2000cwo.goog legroups.com...

Dave wrote:
There is a combo box on the form and another text box
besides it, I
want the
other text box to be activated when a certain selction has
been made
in this
case it is Other from the combo box. Setting the limit to
list to
false does
what to the other text box? Nothing!

<pi********@hot mail.com> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.com.. .
> why not just set the LimitToList property of the Combobox
> to False
and
> then enter whatever you want?
>

jeez, no need to get your knickers in a twist. What I was
implying, jackass, was that you did not really NEED the
textbox at all, because setting the LimitToList=Fal se on the
combobox allows the user to enter any value he wants.

--
Bob Quintal

PA is y I've altered my email address.