Combo Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a combo box on an 'order form' with values imported from one table
(the list of client names). I made the control source be the client name on
the order form. I did this because I did not want to have spelling errorrs or
new clients to be entered on the order form (they must be entered separately
into the client information database). I wanted the user to choose the client
from the list supplied in the client information table and then have that
selection be used for the order form.

The only problem is that instead of putting the name into the "client name"
on the order form, it puts the number that it is in the list (i.e. for the
first client it puts 1 for the second client it puts 2). How do I resolve
this problem? Thank you!
 
Sorry I meant to say that the Row Source comes from Client information and
the control source is the name on the order form
 
I have a combo box on an 'order form' with values imported from one table
(the list of client names). I made the control source be the client name on
the order form. I did this because I did not want to have spelling errorrs or
new clients to be entered on the order form (they must be entered separately
into the client information database). I wanted the user to choose the client
from the list supplied in the client information table and then have that
selection be used for the order form.

The only problem is that instead of putting the name into the "client name"
on the order form, it puts the number that it is in the list (i.e. for the
first client it puts 1 for the second client it puts 2). How do I resolve
this problem? Thank you!
Click to expand...

Set the combo box Column Size property to:
0";1"

Set the Bound column to 1.
Set the control source to the name of the field in the table (LONG
NUMBER datatype) that you wish to save the value in.

The table should correctly store the Client ID number. The combo box
on the form will display the Client Name.
 
Do you know how to simply read in the combo box's value from code. For example
rs!CompanyName = textbox1.Value works for text boxes
how do I do it for combo boxes
rs!CompanyName = combobox1.Value gives me an error message of expected "("
 
Back
Top