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

  • Thread starter Thread starter Christine
  • Start date Start date
C

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
 
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?
 
Back
Top