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

Form returning incorrect data in ControlSource field

P: 10
I have 2 different forms that have synchronized combo boxes (selecting an option in one, changes the options available in the second). The problem is, when I save the record and open the table where the data is going, the field associated with the first combo box is filled with the ID number rather than the text.

I've tried changing the BoundColumn property, but it affects the query/criteria that makes the second combo box function properly.

Appreciate any help on the matter!
Aug 22 '06 #1
Share this Question
Share on Google+
5 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Associate the field as follows:

Me.ComboBox.Column(1) ' refers to the second column, 0 is the first

I have 2 different forms that have synchronized combo boxes (selecting an option in one, changes the options available in the second). The problem is, when I save the record and open the table where the data is going, the field associated with the first combo box is filled with the ID number rather than the text.

I've tried changing the BoundColumn property, but it affects the query/criteria that makes the second combo box function properly.

Appreciate any help on the matter!
Aug 22 '06 #2

P: 10
Associating it like that causes that combo box to not function. It will not let me select any option.

Associate the field as follows:

Me.ComboBox.Column(1) ' refers to the second column, 0 is the first
Aug 22 '06 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
I meant that you should change the association of the field on the form that the combo box populates not the combo box.

Associating it like that causes that combo box to not function. It will not let me select any option.
Aug 22 '06 #4

100+
P: 179
Try this. Open the properties for the combobox, and make the following changes:

Column Count: 2
Column Widths: 0", 1"
Bound Column: 1

Just one word of advice tho. If the table where the data is being stored is in any table other than the main table, then the ID is what should be stored and not the text (that is as long as there is another table somewhere that ties that ID to the text). This saves memory space. You should only ever need to access this data via a form, other than for maintenance purposes.

comteck
Aug 24 '06 #5

P: 10
Yeah, after some struggling yesterday I figured out that I had to play w/ the column counts, widths, and bound column. Thanks for all the help, appreciate it!
Aug 24 '06 #6

Post your reply

Sign in to post your reply or Sign up for a free account.