Cascading Combo Box - filling a text box instead of a Combo box

[Guest]

Hi all, I have my Cascasding Combo Box working great. Setup like so:

lkupBoatNumber-->cboStation-->cboOinCCO

However when I try to make the last 2 (station an OinCCO) a text box vice a
Combo Box all I get is a number. How can I fix this?

Thanks!
Steph

 

[Steve]

Set the controlsource of the first textbox to:
=[cboStation].Column(1)
Set the controlsource of the second textbox to:
=[cboOinCCO].Column(1)

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[StopThisAdvertising]

Set the controlsource of the first textbox to:
=[cboStation].Column(1)
Set the controlsource of the second textbox to:
=[cboOinCCO].Column(1)

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

--
Steve, you have one of two choices:
-- Tell us you will stop advertising here, or...
-- get lost for another year or so...
http://home.tiscali.nl/arracom/whoissteve.html
(Until now 2500+ pageloads, 1840+ first-time visitors)

FYI: (this is also to inform those who do not understand...)
This is *not* about the sigline...although we do not 'love' it, we don't mind the current sigline.
But we will simply continue to hunt down *each and every* of your posts.

It is not relevant whether you advertised in *this* particular post or not...
Your pattern is: You post a few 'good' answers and then start to advertise again.

These groups are *not* your private hunting grounds!
You should know this by now.

ArnoR

 

[Guest]

Hi Steve, I did that but when I make a new selection on my first (master)
combo box, a number only shows up still, not the text.

Am I missing something?

Thanks for the help.

Set the controlsource of the first textbox to:
=[cboStation].Column(1)
Set the controlsource of the second textbox to:
=[cboOinCCO].Column(1)

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

Hi all, I have my Cascasding Combo Box working great. Setup like so:

lkupBoatNumber-->cboStation-->cboOinCCO

However when I try to make the last 2 (station an OinCCO) a text box vice
a
Combo Box all I get is a number. How can I fix this?

Thanks!
Steph

 

[Guest]

Arno, thanks very much. I read with interest your laundry list for Steve. I
would never do business with him, thats for sure. It's kind of sad actually.

But I must ask you: "What did you do here to offer any kind of help to the
original poster.....? "

Just kidding!

Set the controlsource of the first textbox to:
=[cboStation].Column(1)
Set the controlsource of the second textbox to:
=[cboOinCCO].Column(1)

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

--
Steve, you have one of two choices:
-- Tell us you will stop advertising here, or...
-- get lost for another year or so...
http://home.tiscali.nl/arracom/whoissteve.html
(Until now 2500+ pageloads, 1840+ first-time visitors)

FYI: (this is also to inform those who do not understand...)
This is *not* about the sigline...although we do not 'love' it, we don't mind the current sigline.
But we will simply continue to hunt down *each and every* of your posts.

It is not relevant whether you advertised in *this* particular post or not...
Your pattern is: You post a few 'good' answers and then start to advertise again.

These groups are *not* your private hunting grounds!
You should know this by now.

ArnoR

 

[Steve]

Set the controlsource of the master textbox to:
=[cboMaster].Column(1)

All three textboxes will look llike that.

1. If you still are not getting what you want, how many textboxes do you
have?
2. Post what you are using for the row source for each combobox. Show the
fields in each in the order they are in the rowsource.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

Hi Steve, I did that but when I make a new selection on my first (master)
combo box, a number only shows up still, not the text.

Am I missing something?

Thanks for the help.

Set the controlsource of the first textbox to:
=[cboStation].Column(1)
Set the controlsource of the second textbox to:
=[cboOinCCO].Column(1)

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

Hi all, I have my Cascasding Combo Box working great. Setup like so:

lkupBoatNumber-->cboStation-->cboOinCCO

However when I try to make the last 2 (station an OinCCO) a text box
vice
a
Combo Box all I get is a number. How can I fix this?

Thanks!
Steph