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

Auto filling ComboBox?

100+
P: 116
idk why this is giving me such a problem but here it is. I need to add a combobox to a continuous form. This combobox needs to allow the user to select between "S" and "T" for each record in this recordset. I've tried to make it work selecting the values from a table and i've tried just having a valuelist in the combobox. both give me the same result when i run it, when you select a value it automatically selects that value for every combobox. Any suggestions?

Eric
Jun 1 '07 #1
Share this Question
Share on Google+
6 Replies


Rabbit
Expert Mod 10K+
P: 12,366
idk why this is giving me such a problem but here it is. I need to add a combobox to a continuous form. This combobox needs to allow the user to select between "S" and "T" for each record in this recordset. I've tried to make it work selecting the values from a table and i've tried just having a valuelist in the combobox. both give me the same result when i run it, when you select a value it automatically selects that value for every combobox. Any suggestions?

Eric
If it's an unbound control, changing the value will change it for all records. You have to bind the control to a field in the table.
Jun 1 '07 #2

100+
P: 116
If it's an unbound control, changing the value will change it for all records. You have to bind the control to a field in the table.
Any tips on how to add a column to a linked table. It won't let me save a new column in the table. I need to insert the field to bind the combobox to.

Eric
Jun 4 '07 #3

Rabbit
Expert Mod 10K+
P: 12,366
Any tips on how to add a column to a linked table. It won't let me save a new column in the table. I need to insert the field to bind the combobox to.

Eric
You'll have to open up and edit the database that the linked tables are in.
Jun 4 '07 #4

100+
P: 116
Thanks for the help but i found a work around.

Eric
Jun 6 '07 #5

Rabbit
Expert Mod 10K+
P: 12,366
Thanks for the help but i found a work around.

Eric
Could you post your solution in case others have the same problem?
Jun 6 '07 #6

100+
P: 116
It isn't really a solution for this problem i used and action query to add all the rows in one table so i didn't need the combo box to switch between the two tables.
Jun 7 '07 #7

Post your reply

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