make value from combo box appear only in certain rows on subform.

[ladyfame]

On the mainform i have a combo box.
when i select something from this combo box, it goes in to one of the columns on the subform - how do i get this so it only goes in certain rows?

I have column with a checkbox and it is ticked for the rows i want it in.

what do I have to do, to make it do this?

thanks

 

[HiTechCoach]

On the mainform i have a combo box.
when i select something from this combo box, it goes in to one of the columns on the subform - how do i get this so it only goes in certain rows?

I have column with a checkbox and it is ticked for the rows i want it in.

what do I have to do, to make it do this?

thanks

I would use an Update Query.

 

[CEH]

Sounds like a simple If...Then would work.....
If checkbox = True then
SubformField = combobox field
Else
end if
You can also use a Select case statement....

 

[HiTechCoach]

Sounds like a simple If...Then would work.....
If checkbox = True then
SubformField = combobox field
Else
end if
You can also use a Select case statement....

CEH,
How will that navigate through all the records in the sub form?

 

[CEH]

"I have column with a checkbox and it is ticked for the rows i want it in."

I am assuming a checkmark by the row means you want to insert it in the subform.....

 

[ladyfame]

"I have column with a checkbox and it is ticked for the rows i want it in."

I am assuming a checkmark by the row means you want to insert it in the subform.....

well...
i have a combo box on the main form [combo44]
and in the subform i have a column which shows the value i select from the drop down list, this value goes in all of the rows in the column.
i have another column which has a check box - some of the boxes in the rows are checked - some arent, basically i only want the value from the combo box to appear in the same rows as the ones that have a checked check box. i want the values to appear in their own column but in the same rows that have the ticked check box....