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