query as a subform - how to make each item clickable

[kate10123]

Hi All,

I have a blank form and have inserted a subform, this is a table of data from a query. Is it possible to put an on click event on this like as if it was a listbox?

Thanks

Kate

 

[wazz]

you can use On Click for each field/control. for datasheets, you can use the On Current event for each row. the user has to click the far-left grey column where the row-indicator arrow is (or tab, or use arrow keys to get to a new record).