I wonder if anyone has any clever techniques for this. I want to make a db navigator visible in my form, but only if more than one record is being edited. I would like to do this entirely with code inside the form, so I do not have to count the records before using the form.
Right now, the only way I can figure it out is to store the primary key value in the ON AFTER START EEP, then issue a PROPERTY TABLE . . . NEXT and compare the new key value with the saved one to see if I found a new record. If I did, then I make the control visible and issue a PREVIOUS to get back to the first record. This, of course, causes blinking. I would rather be able to consult some property that tells me whether I am on the last record in the record set (without actually changing the record I'm on), or be able to extract the WHERE clause used for the edit command from the form and do a SELECT COUNT to the the number of records. Anyone do anything like this? -- Larry
