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.
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