1

Topic: How to learn coordinates of the selected cell in the subordinate form?

Greetings to all once again. Nevertheless wanted to learn how to define coordinates of the selected cell in the table? Those number of a column and row number which correspond the selected cell.

2

Re: How to learn coordinates of the selected cell in the subordinate form?

;
There is a form, on it the subform with a label... There are some columns for saving of files if to click some times on a specific cell the window for file adding in a DB is caused. After the file is added in a DB, to be exact in a cell the file name after closing of the form of courses it is returned on to 1 period in the first column is brought. Those it is necessary to be returned each time to earlier selected cell. If it is possible as  to learn coordinate of the selected cell, and then it to activate.

3

Re: How to learn coordinates of the selected cell in the subordinate form?

kos20 wrote:

Nevertheless wanted to learn... Number of a column and row number which correspond the selected cell.

Dim c As Control
Set c = Screen. ActiveControl
For i = 0 To Me. Recordset. Fields. Count - 1
If c. Name = Me. Recordset. Fields (i).Name Then p = i + 1
Next i
MsgBox "a line -" and Me. Recordset. AbsolutePosition + 1 and "a column -" and p