find value of selected field in a table

[Bic]

New to Access2007. Need some direction.

I have a form with a subform which displays different tables in the subform depending on criteria from the main form.



What I would like to do in VBA, is get the value of a field selected in the table, similiar to the idea of listindex, column() or value in a listbox.

Any direction is appreciated......

[llkhoutx]

I assume that you're displaying the table in a subform datasheet. You can just copy the field, or on any field's OnClick event do something with the field value. You know the field name.