Referencing Fields on Continuous Subform

[Charles Tam]

On a Continuous Subform, how do I correctly reference one of the fields of
the current record?

For example, I've a button on the continous subform and the button's onclick
event, I've the code "Me.fieldname.value". However, it also returns the first
record. Any ideas?

 

[Marshall Barton]

On a Continuous Subform, how do I correctly reference one of the fields of
the current record?

For example, I've a button on the continous subform and the button's onclick
event, I've the code "Me.fieldname.value". However, it also returns the first
record.

But that is how you reference the value of a field or
control in the current record. To get to any record other
than the current record requires VBA code and the form's
RecordsetClone object.

I suggest that somehow you've managed to make the first
record current (Requery?), or you're misinterpreting the
results you're seeing.

 

[Charles Tam]

Hi Marshall

Thanks for your reply. I've forgotten to select the current record prior to
invoking the code.

Kind Regards
Charles