Is "thisform.lastname" a custom property of the form? Is this first assignment syntax accurate? It's not clear to me where the parameterized view comes in. Does it use ?thisform.lastname in the SELECT SQL?
Is the view "selected"? It would be safer to prefix the field name with the table name...
>I have a parameterized view which has a parameter of 'lastname' (character) and a form which has a property of 'lastname'.
>I also have sample code such as:
>
>thisform.lastname = thisform.lastname1.value
>(lastname1 is a text control)
>
>OK so far.
>
>When the following code executes, I get an error message that 'LASTNAME' variable is not found:
>
>lastname = thisform.lastname
>
>I can set each side of the equation to a value, such as: lastname = "%" and thisform.lastname = "%" without any problems.
>
>Any suggestions. Thanks in advance.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement