How do I reference a specific row,column in a datasheet?

[aregan1]

Hi everyone -

I have a form that displays a datasheet. When I click on a specific row of the datasheet, I want to be able to reference (with VB code) a certain column in that row that I clicked on. How would I reference the field I want?

Thanks for your help...

- Anita

 

[BillPower]

A simple way to demonstrate this is to put the following in the on click event of a control or controls in your datasheet:

MsgBox Me!TheControlYouWantToReferenceName

Change the TheControlYouWantToReferenceName to the Control Name which has it's Control Source bound to the Field you mentioned above. This will display a message box with the contents of each record of TheControlYouWantToReferenceName.

 

[saustin]

Hi Anita,
This is EXACTLY what I need to do today. Did you ever figure out how to reference the row, column on the datasheet (grid)? If so, please share. Many thanks, Steve.