Originally Posted by
missypooh1969
...Even with no data, I would expect to see a form with blank fields, but not a blank form...
Sorry, but that's just the way Access works! If a Form's Record Source has no Records, and the Form cannot be updated, for whatever reason, not even the Controls, themselves, appear!
Allen Browne has an excellent article that explains why Multi-Table Queries are frequently Read-Only:
Why is my query read-only?
As June7 suggested, the best way to do this type of thing is using a Main Form/Subform(s) scenario, with each Form or Subform being Bound to a single Table.
Linq ;0)>
Last edited by Missinglinq; 08-20-2014 at 06:52 PM.
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007