Combo Box

[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!

 

[Guest]

Sorry I meant to say that the Row Source comes from Client information and
the control source is the name on the order form

 

[Guest]

Check the bound column property of your combo box. It sounds like you may
want to change it from a default value of 1 to 2. The bound column represents
the column that will get saved to the foreign key field, specified as the
Control Source.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[fredg]

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!

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.

 

[Guest]

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 "("

 

[Guest]

combobox1.text also does not work (same error) Thanks!!!

 

[Guest]

Debug.Print Me.cboCountry.Column(0)
or
MsgBox Me.cboCountry.Column(0)

where cboCountry is the name of the combo box in this example. The column is
zero-based (ie. column zero corresponds to the first field in the combo box
rowsource.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________