General information
Category:
Coding, syntax & commands
Matt - Open the table the grid is using AGAIN with a different Alias:
* Form Load Code:
Use GridTable In 0
Use GridTable Again In 0 Alias GT_lookup
Put the two tables in the same order so that the lookup table will have the same previous and next rows. Then, instead of using the ActiveCell method you should maintain a property .r_nRowNow_GT which contains the current row as referenced by a reliable lookup key. It can be RecNo() but it is preferable to use a primary key because then you don't have to worry about going to a record that isn't there. You can save the new value in the When code for each of your grid objects. Then when you want to validate the dates above and below, that method can find the record specified by Thisform.r_nRowNow_GT and SKIP or SKIP -1 to get the values above and below.
Adam
>Could someone enlighten me as to how I can reference values in different cells within a grid without using the ActiveCell method?
>Is it possible? I'm trying the verify dates in cells above/below and beside the active cell.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only