By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,806 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

Dropdown list passing hidden values ?

P: n/a

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: +27 31 563-8344 Fax: +27 31 564-4928
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....?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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: +27 31 563-8344 Fax: +27 31 564-4928
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....?

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.