Form datasheet view record onclick (1 Viewer)

[cosmarchy]

If you have a form in datasheet view, is it possible to get the record which was clicked on to use in an event?

Similar to a listbox or combobox when you double click you can get the contents of the record.

Thanks

 

[GPGeorge]

Yes, the "record which was clicked on" will be the Current Record, so if you ask for the Primary Key of the Current Record, you'll get it to use in that event.

 

[cosmarchy]

Thanks

 

[Pat Hartman]

ALL control and form events ALWAYS reference the current record which is the record that has the focus. i.e. the one you clicked in or the first record displayed in the case of a continuous or DS form. Whether the form is single or multi-record is irrelevant. For continuous or DS view forms, the form object is reused. This is why unbound controls always contain identical values in a continuous or DS view. They do in single form view also, you just can only see one record at a time so you don't notice the "duplication".