What is the way for inputing mulitple records on a form?

[alessandro311]

Dear all,

I am developing an Access DB to store some marketing package information.

because the information to be stored is too many, I designed to allow the users to input it on a step by step (like a wizard) approach, and finally insert all data to a table through ADODB.command. Therefore, none of the forms are bind to any table, instead, the ADODB.command would insert the record with a INSERT SQL command.

My question is, one page is used for input the package prizes, which may be different in number for each package, so how can I input a set of prizes (with different no.)through a form ???

thanks for any comments!!!

 

[bronc]

I'm not quite sure what you mean. If you want the user to enter one record at a time, isn't this what one usually does by means of a form?
On the other hand you might wish to enter a (i was almost going to say "bunch" - ugh) block of data and then use either the CommitTrans or Roolback etc methods.