Cannot add data to form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a simple database, one table, one query, and one form. But I
cannot add data using the form. I have to add new data straight into the
table. I've created database's before but this is a first. Any ideas?
 
Is your form's "allow Additions" property set to True?

If the form is based on a query, is the query updatable? In other words,
when you run the query, can you add a new record there? (If this is based
on one table, the answer should be "yes".)
 
I'm having a similar problem! I can't add data into the form (although I can
add it into the subform), and my query is not updateable. The query is based
 
I'm having a similar problem! I can't add data into the form (although I can
add it into the subform), and my query is not updateable. The query is based
on several tables, is this why it is not updateable?
Click to expand...

Most likely. It's generally a Bad Idea to try to base a form on a big, complex
multitable query - and it's generally not needed either. Normally one would
use a Form for the "one" side (master) table, one or more Subforms for the
"many" (child) tables, and combo boxes or listboxes for lookup tables, rather
than incorporating all the tables into the form's recordsource query.
 
Thanks, John, once again for a clear answer!

But just to clarify - can I put subforms within subforms? Or do I put
multiple subforms within the main form? (So, nesting subforms versus parallel
subforms.)

Thanks again,

buggirl
 
Thanks, John, once again for a clear answer!

But just to clarify - can I put subforms within subforms? Or do I put
multiple subforms within the main form? (So, nesting subforms versus parallel
subforms.)
Click to expand...

You can do either, or both. In A2003 and later you can nest subforms an absurd
seven layers deep, and you can easily put multiple subforms in parallel.
 
Back
Top