SAVE COMBO BOX TO MULTIPLE FIELDS

[RICHARD BROMBERG]

I'm using Acess 2000

On the Data Entry Form I have 10 Text fields.

I would like to set these text fields by clicking on differant items in a
Combo (or List) Box.

The first item clicked in the Combo box should be saved in the first of the
10 Text fields,
and the second item clicked in the Combo box should be saved in the second
of the 10 Text fields, etc etc.

Does anyone know how I can make the one Combo box save to the various text
fields?

A Second question:
When setting up a Combo Box you are asked If you want to "remember for later
use" or "store that valie in this field".
If I select "remember for later use", then how do I specify where to
remember it?

Many thanks
Dick B

 

[Chris]

Dick,

On your combo box be sure you do the following:

ColumnCount property should = 10 (for the 10 fields you
want to retrieve)

If you want to show all the columns, specify a width for
each in the ColumnWidths property. If you do not want to
see all of the columns, set each column width to 0 (e.g.,
1.5";0;0;0;0 will show the first column, but not the next
4)

To store the value of a field other than the bound column,
do the following:

Define a text control. Set it's ControlSource to

[comboboxname].column(n)

where comboboxname is the name of the combo box control
and n is the number of columns over that you want to
store. NOTE: Access begins counting by 0, so if you want
the 2nd column, you would define it as
[comboboxname].column(1)

An unbound combo box is one where the wizard asks if you
want to "store the value for later use". The value is
stored in the control until you change it.

Hope this helps...

Chris

 

[RICHARD BROMBERG]

Straight forward and right on target, it worked the first time.

Many Thanks Chris.

Dick B

Dick,

On your combo box be sure you do the following:

ColumnCount property should = 10 (for the 10 fields you
want to retrieve)

If you want to show all the columns, specify a width for
each in the ColumnWidths property. If you do not want to
see all of the columns, set each column width to 0 (e.g.,
1.5";0;0;0;0 will show the first column, but not the next
4)

To store the value of a field other than the bound column,
do the following:

Define a text control. Set it's ControlSource to

[comboboxname].column(n)

where comboboxname is the name of the combo box control
and n is the number of columns over that you want to
store. NOTE: Access begins counting by 0, so if you want
the 2nd column, you would define it as
[comboboxname].column(1)

An unbound combo box is one where the wizard asks if you
want to "store the value for later use". The value is
stored in the control until you change it.

Hope this helps...

Chris

-----Original Message-----
I'm using Acess 2000

On the Data Entry Form I have 10 Text fields.

I would like to set these text fields by clicking on differant items in a
Combo (or List) Box.

The first item clicked in the Combo box should be saved in the first of the
10 Text fields,
and the second item clicked in the Combo box should be saved in the second
of the 10 Text fields, etc etc.

Does anyone know how I can make the one Combo box save to the various text
fields?

A Second question:
When setting up a Combo Box you are asked If you want to "remember for later
use" or "store that valie in this field".
If I select "remember for later use", then how do I specify where to
remember it?

Many thanks
Dick B




.