DB Disaster

[ruthdyson]

Hello All,
I am about to pull out the remaining strands of black hair. There is a database I have worked on for almost a month now. I have the information needed but I can't get the db to work. My buttons won't work regardless of how I code them; I can't get the form to create a new record, and everytime I try to add a record to a table it adds the same records already listed. PLEASE HELP!

Ruth

Copy of PrintMailSvcs.zipAttachment 242611
Copy of PrintMailSvcs.zip

[Norie]

Ruth

Why do your Next Page/Tab buttons try to move to a new record?

If you want to move to the next tab change the value of the multipage/tab.

Private Sub NextTab_Click()
    Me.TabCtl0.Value = Me.TabCtl0 + 1
End Sub

To insert that code select the button, goto the Event tab of the property sheet and select [Event Procedure] for the On Click event.

Also, why don't you use the Invoices table as the record source of the form?

That would make it straightforward to add new records, and you could edit/search/delete existing records.

[ruthdyson]

Forum Guru,
Thank you for your help - that worked and I changed the record source to reflect Tables instead of Forms. Honestly, I never thought about making that small change. Now the only issues I seem to have is when I click on Add Record I'm prompted to enter Parameter Values and four records are automatically added each time but I'm not given the chance to actually go to the next record. Thank you again for all your help and your patience.
Ruth

[Norie]

Ruth

You'll probably not like the idea but it might be worth starting over.

I don't know how you originally created your form but Access has various wizards that will automatically create a form from a table/query.

It can even make forms automatically.

That can be done by selecting the table you want to create the form from, then on the Create tab click Form.

What's created is pretty basic but it might give you a start.

[ruthdyson]

I will try creating another form, although I did create this form with the steps you recommended (it seemed the easiest way seeing that I am rather new to this). While away from this forum I realized that four records were being added possibly because of where I had the "Add Record" button, on the final page of the four. I'll see if that can be changed because I do need the Invoice Total to be the final page before advancing to the next record. Thank you Forum Guru for your help. I am happy to know there are knowledgeable and patient people here willing to help with "Us Beginners"!!!
Ruth

[Norie]

Ruth

No problem.

One thing though, you should never store a calculation like Invoice Total in a table.

Having it on the form is fine, but not in the table.