Selecting a Record in Datasheet view

[JFo]

Not sure if this is possible, however what I have is a search form that filters records (pieces of equipment that are involved in an inspection) displayed in a subform in datasheet view (many different pieces of equipment).

What I want to be able to do is click on the piece of equipment and I want this to open or make another subform visible or perform some (any) action

Is this possible in datasheet view as it displays all the records however I can't select a specific record and use a command button in this view for example

Thanks

[John_G]

Hi -

Yes, that can easily be done. Controls in datasheet view respond to the on-click event the same as they do in any other view, and values for all fields in the record you clicked on are available (even if they are in the record source but not displayed).

[JFo]

Hi -

Yes, that can easily be done. Controls in datasheet view respond to the on-click event the same as they do in any other view, and values for all fields in the record you clicked on are available (even if they are in the record source but not displayed).

Thanks for your response John G so I added a command button that opens another form dependant on the record selected and it works in single form view however I can't even see the command button in datasheet view to click on it

Thanks

[JFo]

Never mind I didn't need a command button I can just code it into the individual controls and it works

Thanks