Subject Re: beginappend() Problem Fixed From Mervyn Bick <invalid@invalid.invalid> Date Sun, 2 Jul 2023 10:57:42 +0200 Newsgroups dbase.getting-started On 2023/07/02 10:04, Lee Grant wrote: > Ken, > > Maybe I didn't explain it properly. > > 1.) I drop first the database object onto the form. Then I drop the > query object onto the form. > 2.) Then I set the database object first, > 3.) and then set the query object next. > > The only difference seems to be, because I dropped both objects on the > form first, and then filled them out in order. That's the only time the > form.rowset property is not being streamed out by the designer. Try it. > Drop both objects on the form without filling either one in. Then fill > in the database object and then fill in the query object, and then save. > Then go look at the source code. There won't be any form.rowset property > line set. It goes a bit deeper than this. :-( I placed a database object and a query object on a form and saved the form. I checked the sourcecode and, although the two objects hadn't been set, the assignment to the form's rowset property was there. I reopened the form in the designer and set the databasename property of the database object and made it active.  The form's rowset assignment was intact. I reopened the form in the designer and set the query's sql property. The form's rowset assignment was unchanged. I reopened the form and made the query active.  David Copperfield at work. :-) POOF!! Assignment GONE even before the form was saved. Mervyn.