Referring to iteration number on a continuous form

I want to put a button on a continuous form. I would like the value
of the button to represent the iteration number of the form.

For example, if a form iterates (continues) for 10 records in a
database table, I would like the value of the button on the form to
represent the "index" number of the continuous iteration the button is
located on (0-9).

Any suggestions?

THANK YOU!

And what is the button supposed to do?
I did find something interesting while thinking of your question. The
VB editor allows Value as a command button property, but it cannot be
used (in A97 anyway). A command button seems to actually have no value
property.

So for your case, a button may not be doable.

I want to use the VALUE property to pass as a parameter to an SQL
stored procedure that is being executed by Access. The parameter
would be equal to the "row number" of the table, but I cannot use that
property as I am using a continuous form and not a datasheet to
display the table.

I also have an ID column that would work, but I would be facing the
same problem as I would have to grab the ID value FROM THAT ROW to
pass to the query. Do you understand what I mean? If you want me to
send a screen shot or something, let me know.

I'm not sure how the row number will help you. I'm not aware of sql
being able to manipulate that as it's not really part of the record.
Referencing the ID field would be the same as the button and I'm not
sure that datasheet and continuous views have anything to do with it
either. What is the query you are attempting to use? Perhaps you just
need guidance on how to structure it. Include the names of the fields
in the form that need to be referenced as criteria.

On Mar 22, 5:39 pm, "jtertin" <jter...@gmail.comwrote:

Quote:

I want to use the VALUE property to pass as a parameter to an SQL
stored procedure that is being executed by Access. The parameter
would be equal to the "row number" of the table, but I cannot use that
property as I am using a continuous form and not a datasheet to
display the table.
>
I also have an ID column that would work, but I would be facing the
same problem as I would have to grab the ID value FROM THAT ROW to
pass to the query. Do you understand what I mean? If you want me to
send a screen shot or something, let me know.

It sounds like you need .bookmark and .recordsetclone. -tc

Referring to iteration number on a continuous form

re: Referring to iteration number on a continuous form

re: Referring to iteration number on a continuous form

re: Referring to iteration number on a continuous form

re: Referring to iteration number on a continuous form

/bytes/development

/bytes/it

/bytes/about