Form w/subform will not add new records?

  • Thread starter Thread starter Nancy
  • Start date Start date
N

Nancy

I have a form and a subform. The record source for both is a seperate table.
When I add info to the form/subform the info is added to the table fine.
The problem is that I only have the option of three forms/subforms. If I try
to add more it defaults to the first form. I checked that my master/child
are linked and allow additions is clicked to yes. I did a search for this
problem before I posted and those were the only responsed that I ran across
that sounded like my problem. I am using access 2007 and am pretty new to
it. Does anyone have any ideas? I would appricate any help with this
issue. I am almost done with this database and just have three errors that I
need to resolve and this is one of them. Please help me, I have another job
offer but don't want to move on until I finish this job.
 
The problem is that I only have the option of three forms/subforms.
This does not match the subject of your post - Form w/subform will not add
new records?
Are you trying to add records or subforms?
 
Sorry for the confusion. I hae a form and I add info to the form and subform
and all works fine. I want to go to the next record and add a new record.
Across the bottom of the form there is the: Record 1 of 1, 2 of 2, 3 of 3.
I can't get to number 4 and greater. I want to enter info into this form
with is an invoice. The subform is detailed information about the purchased
products. The form itself is the Invoice number, supplier, shipping, etc. I
want to put all my info into the form and save it. Then I want a new clean
form to open up so I can do another invoice for a different purchase. It may
be the same supplier and it may be a different supplier. So each time I
enter a new informantion into the form it will save it and all. But when I
try to do record number four it will not let me. It is like it is stuck to
record #3. Does that make any sense? Thank you so much for any help you can
give me.
 
Across the bottom of the form there is the: Record 1 of 1, 2 of 2, 3 of 3.
This is called a navigation pane. There should be one for the main form and
another for the subform.
Which navigation pane will not go to 4?

I assume that the main form is your Invoice form. Post the SQL of the query
that feeds the form. Open the query in design view, click on menu VIEW - SQL
View, highlight all, copy, and paste in a post.

If your form does not use a query then open the form in desogn view, click
on menu VIEW - Properties and read the Record Source. Copy and post that.
 
Back
Top