can i have two bound column in combo box

[girjer]

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

[Rabbit]

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.

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

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>

[Rabbit]

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:

DoCmd.RunSQL "UPDATE ..."
DoCmd.RunSQL "UPDATE ..."