🚀 go-pugleaf

I am trying to use the rowset onNavigate event to populate unlinked
entryfields on my form. I am using the following code:

function rowset_OnNavigate()
if .NOT. (form.members1.rowset.endOfset)
    class::refreshUnlinked()
endif

Whenever I try to navigate (using a grid control) I get the message:

   Error: Variable undefined: FORM

I do, however, call the above OnNavigate function from the OnOpen event of
the query object and that does not cause an error message. I have tried
explicitly referencing the form object and passing the form object as a
parameter to the OnNavigate function but to no avail.

Can anyone help me out here?

If I use the 'this' keyword instead of 'form.members1.rowset' it seems to
work as it does call the refreshUnlinked function but therein lies another
problem.

My refreshUnlinked function attempts to assign values to unlinked
entryfields on my form by performing arithmetic on fields in the rowset,
i.e:

form.ef_balance.value = form.members1.rowset.fields["DUE"].value - ;

form.members1.rowset.fields["PAID"].value

This gives me:

    Error: Data type mismatch. Expecting: Object

Huh!

Help. I am confused.

Andrew Knight
Gaborone
Botswana