Acess 2003 - use Forms to create Purchase Order

W

Want2Learn

I need access automatically create new rows. For Ex
Qty Product Price Total (when total entered,new row created for
next entry)
Qty Product Price Total
 
J

John Vinson

I need access automatically create new rows. For Ex
Qty Product Price Total (when total entered,new row created for
next entry)
Qty Product Price Total

Don't forget, the Form is distinctly secondary: it doesn't contain any
data.

If you have a Table with these fields, you can create a Continuous
Form based on the table; when you tab out of the last field it will
create a new record and tab into the first field.

Do note that you should probably NOT have a Total field in your table,
if it can be calculated by just multiplying Qty times Price. Instead,
base your Form on a Query with Total as a calculated field.

John W. Vinson[MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top