I have added several subforms to one main form. Two are working fine but 3 won't let me add a record unless there already exists at least one record (entered via table). They otherwise seem to work fine i.e. in synch with main form and underlying tables. Any suggestions where to look for the problem. thanks -- Helen
Do any of these three happen to have any of their recordsources in common? In other words are any of them updating the same tables? -- Bob Larson Access MVP Free Tutorials and Samples at http://www.btabdevelopment.com __________________________________ "Helen" wrote: > I have added several subforms to one main form. Two are working fine but 3 > won't let me add a record unless there already exists at least one record > (entered via table). They otherwise seem to work fine i.e. in synch with > main form and underlying tables. Any suggestions where to look for the > problem. > thanks > -- > Helen
Yes Bob they are. I had repair, maintenance, monitor acitivity logs all in one Remedial Table but split the logs into subforms because sometimes one has several entries while another has none so it would be clunky - the number of records would be meaningless and scrolling through would take you from e.g. a maint record to a repair record etc rather than the next main record. I can split the table if that's all it is. Thanks. -- Helen "boblarson" wrote: > Do any of these three happen to have any of their recordsources in common? > In other words are any of them updating the same tables? > -- > Bob Larson > Access MVP > Free Tutorials and Samples at http://www.btabdevelopment.com > > __________________________________ > > > "Helen" wrote: > > > I have added several subforms to one main form. Two are working fine but 3 > > won't let me add a record unless there already exists at least one record > > (entered via table). They otherwise seem to work fine i.e. in synch with > > main form and underlying tables. Any suggestions where to look for the > > problem. > > thanks > > -- > > Helen
Bob, To add to my previous reply, I have other forms that update the same master table. They are separate stand alone forms though, not subforms - why don't they have the same problem? What is unique to subforms? -- Helen "boblarson" wrote: > Do any of these three happen to have any of their recordsources in common? > In other words are any of them updating the same tables? > -- > Bob Larson > Access MVP > Free Tutorials and Samples at http://www.btabdevelopment.com > > __________________________________ > > > "Helen" wrote: > > > I have added several subforms to one main form. Two are working fine but 3 > > won't let me add a record unless there already exists at least one record > > (entered via table). They otherwise seem to work fine i.e. in synch with > > main form and underlying tables. Any suggestions where to look for the > > problem. > > thanks > > -- > > Helen
