Append a database in a form. (New to Access 2007)

  • Thread starter Thread starter Dan55
  • Start date Start date
D

Dan55

I have created a database and a form in Access 2007. I can view data in the
form, but I can't append. I have been manually entering info in the database.
Would like to use the form to enter info. Not exactly new to databases, I
used dBase in DOS for 10 years. Any assistance would be appreciated.
 
In form design view, open the Properties sheet.

Looking at the properties of the Form (not of a text box), what is the
RecordSource property (on the Data tab of Properties sheet)?

You will be able to add records if the RecordSource is just one table, or a
query that uses just one table. If the query contains 2 tables, you may find
you can't append or can't edit, or that you can append to one of the tables
only (depending on indexes/relations between the tables.)

So, simplify the query. Perhaps use a subform to show the related data.
 
Back
Top