Update subform Datasheet

[mattc66 via AccessMonster.com]

I have a drop down box on my main form to select the customer discount level.


I want to be able to select that discount level and have it copy that to a
feild on my subform for each line item.

Below is the code that is not working.

Dim rst As Object

Set rst = Me.sfrmOrdersSubform.Form.Discount.RecordsetClone
Do Until rst.EOF
rst.MoveNext
Loop

Can anyone help?

Thanks
Matt

 

[Sylvain Lafontaine]

Not sure but what the word .Discount. is doing here after the word .Form. ?
I would have thought that you are trying to edit the recordset or the
recordset of the subform, not the recordset of a control on this subform.

 

[mattc66 via AccessMonster.com]

Okay maybe I was not clear - it's not working..

I want to take the data found in the DISCOUNT fld from my Main Form and drop
that same data into the same FLD name found in my Subform. Which is a
datasheet. It could have 20-30 records all needing the DISCOUNT fld to read
the same data.

Not sure but what the word .Discount. is doing here after the word .Form. ?
I would have thought that you are trying to edit the recordset or the
recordset of the subform, not the recordset of a control on this subform.

I have a drop down box on my main form to select the customer discount
level.

[quoted text clipped - 15 lines]

Thanks
Matt