Hi gang,

SET DEVELOPER FRUSTRATION TO HIGH

I'm pulling what few hairs I have left out on this one. I have an UPDATE-SQL command, executed from a command button on a page of a pageframe, that alters a record in an updateable local view, with multiple items to SET, as follows:

loParent = THIS.Parent

UPDATE ;
    vwSubscriberOne ;
  SET ;
    cLastName  = loParent.txtLastName.Value, ;
    cFirstName = loParent.txtFirstName.Value, ;
    etc. etc. ;
  WHERE somecondition

The command refuses to execute, telling me that "Alias txtLastName is not found". A similar INSERT-SQL command, in the same method of the same command button, uses the *identical* loParent.txtLastName.Value reference without a complaint.

What the @#$%^&* am I missing here?

TIA,