Repeat same action, but for different row.

[in2ition]

Hello everyone,

I have an Access Form called Database_Form, with a text box called Text22, and a button called Command42.

I also have a table, and query, as following:

Table 1, as in the below example:

Row_Number	Column2	Column3	Column4	Column5	Column6
1	0026007101	01	001	*	2101
2	0026007101	01	002	*	2101
3	0026007102	01	001	*	2201
4	0026007102	01	002	*	2201
5	0026007102	02	001	*	2203

<caption>
</caption> <thead>
</thead> <tbody>
</tbody> <tfoot></tfoot>

Query 2, which has the criteria [Forms]![Database_Form]![Text22] for Row_Number Field.

Basically, i want that each time when i press the button Command42 and having the text box filled with value 1 (for row number 1), to repeat this step, but taking the next row_number and so on, until it finishes the last row.

The Query 2, should sequentially select the row number given in the text box, based on a VBA Code or something.

Is there any VBA code in order to achieve this ?

Thank you.

 

[xenou]

Hi,
If row number is a field in the database then you would only need to select the records in sorted order and use the standard navigation feature in Access. Each time you move forward one record it will be the next row number. As a general rule, database theory is not dependent on the ordering of rows. But a sequential numbering of records such as the one you have will allow you to move through the records in order.
ξ