Form w/subform will not add new records?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nancy - 11 Apr 2008 01:40 GMT

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.

Reply to this Message

KARL DEWEY - 11 Apr 2008 17:09 GMT

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

Signature

KARL DEWEY
Build a little - Test a little

> 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.
[quoted text clipped - 7 lines]
> 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.

Reply to this Message

Nancy - 11 Apr 2008 19:58 GMT

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.

> >>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
[quoted text clipped - 12 lines]
> > 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.

Reply to this Message

KARL DEWEY - 11 Apr 2008 22:41 GMT

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

>>I can't get to number 4 and greater.

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.

Signature

KARL DEWEY
Build a little - Test a little

> 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.
[quoted text clipped - 26 lines]
> > > 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.

Reply to this Message