Acess 2003 - use Forms to create Purchase Order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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]
 
Back
Top