Need to stay on first sheet

[e b]

I have an inventory database. I have two tables.

One for people, TblPeople. One for invoices, TblInvoice.

TblInvoice has invoice as a primary key (autonumber)

I have a query that will create a new invoice number whenever

I input a new customer number. Great.

My problem.

On the form, whenever I create a new number, it creates a new blank sheet (2
of 2).

How do set it to not create a second blank sheet and stay on the first sheet
with my new number (1 of 1)?



EB

 

[John W. Vinson]

I have an inventory database. I have two tables.

One for people, TblPeople. One for invoices, TblInvoice.

TblInvoice has invoice as a primary key (autonumber)

I have a query that will create a new invoice number whenever
I input a new customer number. Great.

Well... not so great, I fear. Creating an empty "placeholder" record is
generally neither necessary nor a good idea.

Since a person very well might have two or more invoices (surely you want
repeat business!) you may want to consider using a Form for People, with a
Subform bound to the Invoices table; use the PersonID as the master/child link
field. This will allow you to enter an invoice when you have data for that
invoice, and have it automatically inherit the foreign key to tblPeople.

If you're entering data directly in tables... don't. Tables are for data
storage, not for interacting with data; accordingly they have very few tools
available for working with data. Forms on the other hand have a rich set.

John W. Vinson [MVP]