If I have data on a form displayed in the datasheet view, is there a way to refer to the rows and columns of the datasheet?

Thanks,

Ray

What do you mean when you say "refer"? Do you mean with code? You can do that, but you would have to know what you were going after and refer to the PK of the row, and the column by name, which is probably not what you want to do. Change the datasheet to a continuous form to refer to the data.

Did that help any?

mmcdonal

The row can be referred to simply by the record number of the data on the form. The column can only be referred to by naming the actual field.

As for datasheet vs. continuous forms, that's a matter of functionality. Most time when I list data, I do in datasheet view. I don't use a continuous form unless I wish to put a control, e.g. command button, along with each record.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Thanks Guys, Sorry I didn't get back sooner, but, as sometimes happens, changes were made to the process and my problem went away :) I appreciate the responses.

Ray