fill in values in a column after selecting a value from a combo box

[Sym]

I have a form that is a datasheet. it contains multiple records. One of the fields in that datasheet is a combo box. I would like to make it so when I select a value from the combo box it changes all the values of the other records in that column/field to what was chosen from that combo box. is that possible? does that make sense?

 

[MarkK]

Yes, it's possible, but no, it doesn't make sense.

If all records will always have the same value in a particular field, then that field belongs in a different table, somewhere it can be stored once, authoritatively.

 

[Sym]

sorry, again, I was not specific enough. This is for a subform datasheet on an order form and not an entire table so the data wont ALWAYS be the same as the information on the form will change based when its opened and the primary key of the parent form (which is the order number). all I want to do is auto populate all the values for that field in the subform which is usually at tops 10 records.

 

[pbaldy]

Mark appears to be offline. I think his point is that if you want every detail item for an order to have the same value, then it makes more sense to store that single value at the order header level. In other words, on the parent form rather than the subform. It might help if you describe what the value represents.

 

[MarkK]

Mark appears to be offline. I think his point is that if you want every detail item for an order to have the same value, then it makes more sense to store that single value at the order header level. In other words, on the parent form rather than the subform. It might help if you describe what the value represents.

Thanks Paul, absolutely right on all counts.