forms combo box is data for update query

[tubar]

i have query"X" with all the records that have true values in their checked box. now on a seperate form the user selects a value from a combo box and i want all the records from the "X" query to update to that value...i think i need an update query and some code on the after update of the form with the combo box...could you tell me the steps

 

[John Big Booty]

Yes you will need an update query.

You will need to use;

Forms!FRM_FormNane!ComboName

to return the value of the Combo in your query.

 

[tubar]

i place that in the update to column of the update query

 

[tubar]

it works...thanks man

[Forms]![1]![Combo1]

 

[John Big Booty]

it works...thanks man

[Forms]![1]![Combo1]

Good work