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

can i have two bound column in combo box

P: 3
I need to update two fields in the database table using one selection of combo box.
For e.g.
When user selects "YES" in a combo box, i need to populate two table fields Quesvalue=100 and Quesscroe=200 ( I can use these two files as hidden field in combo box)

Any suggestions?

Thanks,
Girjer
Aug 9 '07 #1
Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,392
I need to update two fields in the database table using one selection of combo box.
For e.g.
When user selects "YES" in a combo box, i need to populate two table fields Quesvalue=100 and Quesscroe=200 ( I can use these two files as hidden field in combo box)

Any suggestions?

Thanks,
Girjer
You can't bind two fields to a combo box but you can use the after update event to populate more than one field.
Aug 9 '07 #2

P: 3
You can't bind two fields to a combo box but you can use the after update event to populate more than one field.
Please let me know a simple query to write two update statements within one action piece of code either in Access or VB code to use in after update event.

for e.g.
I want to two update statements to be run on a single click of button
i.e.
1. update <table_name1> set field1=100 where <condition>
2. update <table_name2> set field1=200 where <condition>
Aug 10 '07 #3

Rabbit
Expert Mod 10K+
P: 12,392
Please let me know a simple query to write two update statements within one action piece of code either in Access or VB code to use in after update event.

for e.g.
I want to two update statements to be run on a single click of button
i.e.
1. update <table_name1> set field1=100 where <condition>
2. update <table_name2> set field1=200 where <condition>
It'll look something like this:
Expand|Select|Wrap|Line Numbers
  1. DoCmd.RunSQL "UPDATE ..."
  2. DoCmd.RunSQL "UPDATE ..."
  3.  
Aug 10 '07 #4

Post your reply

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