Multiple Record Entry

[JayCaee]

Hi,

I'm fairly new to ASP and I've developed a basic form which then records the user's entry into an Access Database. What I would like to do however is to repeat the form several times on the page, say 9, in order for users to be able enter multpile records. I would like each entry to be recorded as a new record, so in effect the user could enter 9 records by using the one page.

I hope that makes sense. Is this possible?? If so, how??

Thanks in advance.

JC

[Alan]

I am not totally clear on what you are asking, but if I understand correctly you wish to add multiple records to a database. Now I haven't done that before but I think it could be done, but this would require multiple use of the AddNew and Update methods within the asp page as these only work on single records at a time.

[JayCaee]

I would like a setup were the fields are repeated, so:

Field one
Field two
Field three

Field one
Field two
Field three

Field one
Field two
Field three

Field one
Field two
Field three

So that the user can enter 1 record, or 2 or 3 or 4 records.

Does that make sense.

Cheers,

John.

[Alan]

Yes it does now. You would need to be able to check how many records to be updated, and for each one use the AddNew and Update methods.

For example you could check to see if field 1 on each set had an entry in it, and count how many to include. You would then set up variables to read the contents of the fields for the first record, then add this, repeat for the second and so on until all are entered successfully.