Add multiple items to a purchase

[darcy]

hi, i have a system that allows multiple items to a perchase. - the query works fine and now its time for the form to do it all pretty like.

Can anyone advise me on:

how to increment the purchase id for the form when opened to make each purchase new - does the code go on the button, or the form?

On the form there is a search button that looks up the db to display the data (and to make sure its in the db), I cant figure out the button command to add that data (item_code , cost and quantity) to the subform and not erase the previous value if adding another product!!

I think ive been staring at the code and forms for so long I cant see the problem!!

Does anyone have a fresh perspective to help me out

Thanks.

 

[daveUK]

Darcy,

The purchaseID should be an autonumber field and will automatically increment with each new record.

In order to add a new record, just place a cmd button onto the form and follow the wizzard to add a new record.