I have a form built by the OOo 2.0 wizard from a Mysql table; it contains text box controls linked to all the database fields. If I change the value of a control by typing, the new value gets correctly written to the database. However, if I change the value from within a Basic macro, the update does not get performed. Obviously there is something else I need to do; any idea what?
I did try setting the form's 'IsModified' property to TRUE, but then I got an 'Error writing to database' message, to the effect that the 'KeyName' field was empty. KeyName is the name of the primary key field, and of course did in fact contain a value. (This was not the field modified by the Basic code). -- Cheers, TonyB --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
