Subject applylocate not working
From Charlie <tm@tc,com> <Charlie <tm@tc,com>>
Date Fri, 07 Jun 2024 10:43:35 -0400
Newsgroups dbase.getting-started

I thought this would be easy since I have done this before but the apply locate is never found.  tgrade is what i am trying to find.  actually it represents a field in the table.  so that isn't the problem (yet) because this never finds tid and cat which are also strings.

i have tried this looking for bith variables and only one which certainly should have been found, but for some reason the applylocate doesn't work.

Can anyone help?

function COMBOBOX4_onChange()
           co = form.coins1.rowset
           tgrade = trim(form.combobox4.value)
                tid = trim(form.entryfield5.value)
                tcat= trim(form.combobox2.value)
                //co.applylocate("year= '" + tid + "'")// and category= '" + tcat + "'")
                co.applylocate( "year= '" + 'tid' + "' and category= '" + tcat + "'")
                form.entryfield1.value = val(co.fields["&tgrade."].value)
                //if found()
                   msgbox( ""+found() )