display textbox in continuous form

[luanhoxung]

hi all!!
i get small trouble in display a text box.
My text box will be show a value string base on my combo box choice.
But text box always get the same value when i choose a new value in combo
box.
ex:
combo box---text box
AA 123<--change 456<--change 789
BB 456 <--change 789
CC 789
how can i fix the value of text box after choosing value of combo box ?
Pls help ?
i showed this matter but maybe i showed it in hard words so i didnt get
any answer.
thanks !
Luan from VietNam

[Wayne Gillespie]

On Mon, 02 Oct 2006 23:38:43 -0400, "luanhoxung" <lu********@yahoo.comwrote:

>hi all!!
i get small trouble in display a text box.
My text box will be show a value string base on my combo box choice.
But text box always get the same value when i choose a new value in combo
box.
ex:
combo box---text box
AA 123<--change 456<--change 789
BB 456 <--change 789
CC 789
how can i fix the value of text box after choosing value of combo box ?
Pls help ?
i showed this matter but maybe i showed it in hard words so i didnt get
any answer.
thanks !
Luan from VietNam

In the AfterUpdate event of the combo put -

Me.MyTextBox.Requery

Change MyTextBox to the name of your control.
Wayne Gillespie
Gosford NSW Australia

[luanhoxung]

thanks!
but it seem not effect.
any action for this ?
waiting any replying ?!
Luan from VietNam

[Bas Cost Budde]

Have you got anything in the Controlsource of the textbox?

if [controlname].requery doesn't seem to work, will me.recalc do?

luanhoxung schreef:

hi all!!
i get small trouble in display a text box.
My text box will be show a value string base on my combo box choice.
But text box always get the same value when i choose a new value in combo
box.
ex:
combo box---text box
AA 123<--change 456<--change 789
BB 456 <--change 789
CC 789
how can i fix the value of text box after choosing value of combo box ?
Pls help ?
i showed this matter but maybe i showed it in hard words so i didnt get
any answer.
thanks !
Luan from VietNam

--
Bas Cost Budde
Holland
www.heuveltop.nl/BasCB/msac_index.html

[salad]

luanhoxung wrote:

hi all!!
i get small trouble in display a text box.
My text box will be show a value string base on my combo box choice.
But text box always get the same value when i choose a new value in combo
box.
ex:
combo box---text box
AA 123<--change 456<--change 789
BB 456 <--change 789
CC 789
how can i fix the value of text box after choosing value of combo box ?
Pls help ?
i showed this matter but maybe i showed it in hard words so i didnt get
any answer.
thanks !
Luan from VietNam

You have a combo. It has 3 choices; AA, BB, CC. When the combo is
updated, you want to stuff a string into a text box.

Where does the string come from? From the combo? If so, we'll assume
your combo is multicolumn. The Column Index starts at 0. So if there
are 3 columns in a row, ex:
AA 123 Hello
then AA would be column0, 123 would be column1, and Hello column2

In this case, in your AfterUpdate event for the combo box, you could do
something like
Me.Textbox = Me.ComboBox.Column(1)
to stuff 123 into the text box.

For what it's worth, you can update the Text box from the AfterUpate
event of the combobox.

[luanhoxung]

good everning !
my textbox(unbound control)just display the text string of 1 field. its
controlsource is nothing.
any help with appreciated.
Luan

[luanhoxung]

hi Salad !!
my string of text box from 1 field of table.
and noted that my textbox just display a string for the users in viewing.
it's not be store in any field.
thanks ur reply !
Luan from VietNam

[Jamey Shuemaker]

luanhoxung wrote:

hi Salad !!
my string of text box from 1 field of table.
and noted that my textbox just display a string for the users in viewing.
it's not be store in any field.
thanks ur reply !
Luan from VietNam

It sounds like you are displaying human readable text based on the
value in the combination box.

As noted, you can use the Value property of the combination box to
execute a DLookup function and provide the data to the text box or you
could just set the RecordSource of the combination box to something
like:

Select MyTable.FieldIdentifier, MyTable.[Field you want the user to
see]
FROM MyTable;

and set the combination boxes's RowSourceType property to Table/Query,
the ListWidth property to 0";1", where the 1" is equivalent to whatever
space you need to see the entire field that the user will see on the
screen, and the BoundColumn property to 1.

This way your user will see the human readable value even though the
actual value of the combination box will be equivalent to
FieldIdentifier.

If you decide to use a seperate control to display the human readable
value, I would use a Label and set its Caption property to the human
readable value or use a TextBox and set its Locked and TabStop
properties to 'No'.