subforms

  • Thread starter Thread starter Helen
  • Start date Start date
H

Helen

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
 
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

__________________________________
 
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.
 
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?
 
Back
Top