Display value from drop-down list in a form & store value

[Christine]

My employees database contains a field called Department,
which is a drop-down list with stored values (HR, Finance,
Engineering, etc.)

For a form I want to create to show information from the
Employee's table (which users cannot edit), I do not want
the Department output to show as a drop-down box - I only
want the value to display. When the user double-clicks the
department, I want the value stored to memory for use in
another form.

As I'm VERY new to all this any help will be greatly
appreciated.
Christine

 

[Wayne Morgan]

When you make the selection using the combo box are you storing the text (i.e..
Department) or are you storing an ID that refers to Department in a table?

If you are storing the text, you should be able to simply bind the textbox to the field
that has the information. If you are storing the ID, you need to add the table that holds
this information to the query feeding the form. It will be linked on the ID field. You can
then add the text field from this additional table to the items returned by the query and
bind the textbox to that field.

When you say you want to double click the field and use the value in another form, is the
other form open or are you opening it with the double click?