Referencing Fields on Continuous Subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Charles said:
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.
Click to expand...


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.
 
Hi Marshall

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

Kind Regards
Charles
 
Back
Top