Dropdown list passing hidden values ?

[Les Juby]

Simple problem that's stumping me at present.!

We have created a data capture form in Access 97 which uses a dropdown
list which has been populated from a table.

The dropdown list displays the values from Field-A but there is also
an ID value associated with each record which will not be displayed to
the person filling in the form. But when we take the contents of the
form to add it as a new record in another table, we want to add the ID
field value and not the selected values which the user saw.

So the problem is; how do we display one field in the dropdown box and
not show the other field, and then how do we select the other field
value for appending to the next table.?

thanks

.les.

o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o
Les Juby le*****@anti-spam.iafrica.com
Webpro Internet - - - Prosoft Microsystems
Durban, KwaZulu-Natal, South Africa
P.O.Box 35243, Northway 4065, South Africa
Tel: [phone] Fax: [phone]
o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o
(you *do* know to take "anti-spam" out the address....?

[Mike Storr]

Include the field you want to store (ID) in the query for the controls
RowSource. Set the BoundColummn property to the column number for this
field - remember it is 0 based so if the field is the first in the query,
then set it to 0, 1 for the second column etc.
Change the ColumnWidths property to hide the column you don't want
displayed. This is done in this format 1.5"; 0";0" etc. Set any hidden
columns to a width of 0"

Mike Storr
www.veraccess.com
"Les Juby" <we****@webpro.co.za> wrote in message
news:40***************@news.uunet.co.za...

Simple problem that's stumping me at present.!

We have created a data capture form in Access 97 which uses a dropdown
list which has been populated from a table.

The dropdown list displays the values from Field-A but there is also
an ID value associated with each record which will not be displayed to
the person filling in the form. But when we take the contents of the
form to add it as a new record in another table, we want to add the ID
field value and not the selected values which the user saw.

So the problem is; how do we display one field in the dropdown box and
not show the other field, and then how do we select the other field
value for appending to the next table.?

thanks

.les.

o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o
Les Juby le*****@anti-spam.iafrica.com
Webpro Internet - - - Prosoft Microsystems
Durban, KwaZulu-Natal, South Africa
P.O.Box 35243, Northway 4065, South Africa
Tel: [phone] Fax: [phone]
o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o
(you *do* know to take "anti-spam" out the address....?