Creating new rows for data entry in Access forms

[simhan_chari]

Hi

I am creating a simple data entry form wherein the user will enter the product id and on change the product description and retail price must be displayed.

When the order quantity is entered, the total cost need to be calculated. I am able to do this using DLookUp and simple multiplication.

However, after doing the above, I need another row to appear so that I can accomplish the same for another product.

Please can you help me with this? I have been looking for a solution the whole day.

Many Thanks
Chari

 

[burrina]

Not sure how you have things setup but you should have either a datasheet or a continuous subform for products for the same order.

FYI: If you all you want to is go to a new record, then.

DoCmd.GoToRecord , "", acNewRec

 

[RainLover]

You don' need to do anything.

If you have a datasheet then when you tab away from the last record a new record is created.

Best if you use Auto number for the ID Primary key.