Thanks Clive,
I think I don't need to link form and subform. The subform has a recordsource restricted with three independent fields of the form, but seems that the requery of this subform was a little slow.
I'm trying to run the same code with two separate forms instead a subform but I'm getting the same slow effect.
I only use the subform to browse into records and translate data to form independent fields for modifying or deleting. All the actualizations of the table are doing with ADO methods in the principal form.
For your last question, no, I don't know what are you referring with
"normalization". I would appreciate if you could send me a reference or documentation of this theory.
Thanks another time Clive.
Best regards
--- In MS_Access_Professionals@yahoogroups.com, "Clive" <zctek@...> wrote:
>
> Hi, Tome,
>
> The SubForm should be linked to the Form by some
> common field. Also if you are intending to add
> data to the subform, then the SubForm AllowAdditions
> property should be set to True.
>
> By doing that, when you move to a between records
> on the Form, the SubForm will show all records that
> have a matching value.
>
> Have you normalized your tables? Do you understand
> what Normalization is?
>
> Regards, Clive(Williams)
>
> --- In MS_Access_Professionals@yahoogroups.com, "Tomeu" <tomeugamundi@> wrote:
> >
> > Hi, I'm newbie in MsAccess not in programming
> > I have a doubt about an Access form where I'm adding, modifying an deleting records of a table with independent textboxes and ADO methods.
> > Below these textboxes and buttons I have a subform with a query of the same table (with restrictions). Every time I acualize the table with ADO method, I do a subform requery.
> > All is running ok but for instance I have no records in subform, and I add a record, it doesn't appear in subform after five or six seconds (I'm .requering the subform), the second record I add appears in 3 seconds and other modification or addings appears inmediatly in subform.
> > It seems like ADO methods and subform actualization with recordsource took different ways.
> > Anybody knows something about this effect? It's a little annoying effect
> > Thanks in advance
> > Best regards
> >
>
Tidak ada komentar:
Posting Komentar