myfathersson
New Member
- Joined
- May 4, 2010
- Messages
- 22
Hi.
I'm sure this is easy but I'm darned if I can figure it out.
I want to load a table record into a form based on the current row, i.e., the row containing the selected cell. I already have the VBA code to load the form based on a row number relative to a column range in the databodyrange of the table. The row number in this code is supplied by match.
How can I find out what the row number is of the row containing the selected cell where the row number is relative to the rows in the table databodyrange?
Usage: I have a form I use to add and modify table records (rows). When modifying data, I enter a transaction number in the form which then looks up the transaction number using Match, which returns the row number (location in the column range) and then the form loads the data for that record. After making changes the form writes the record out, overwriting the old data for that record with the new data. I want to be able to do a search in the table outside of the form and then load the data from the record (row) in which search selected the cell containing the found data. For instance, if search selected a cell in table row 3, then I need a way to return table row number 3.
I'm sure this is easy but I'm darned if I can figure it out.
I want to load a table record into a form based on the current row, i.e., the row containing the selected cell. I already have the VBA code to load the form based on a row number relative to a column range in the databodyrange of the table. The row number in this code is supplied by match.
How can I find out what the row number is of the row containing the selected cell where the row number is relative to the rows in the table databodyrange?
Usage: I have a form I use to add and modify table records (rows). When modifying data, I enter a transaction number in the form which then looks up the transaction number using Match, which returns the row number (location in the column range) and then the form loads the data for that record. After making changes the form writes the record out, overwriting the old data for that record with the new data. I want to be able to do a search in the table outside of the form and then load the data from the record (row) in which search selected the cell containing the found data. For instance, if search selected a cell in table row 3, then I need a way to return table row number 3.
