populate multiple rows using one form (looping?)

[atula7]

Hi,
I am new to access and I am using MS access 2010 .MDB database.



I have a table called "ClientTbl" with several fields. I am trying, by using a single form, create (populate) several records (rows) in this table. All the rows supposed to be the same except “Client_nickname” (text), which value supposed to be letters “PB” + “Client_ID"(autonumber) .

1) first i need by typing a number in specific field of the form to set the number of new records (rows)

2) second I would type values into fields of the same form - like (DateOfEvent (date), PlaceOfEvent (text), event (text) etc.)

3) than the loop or macro or whatever you think the best solution is - would use the “Customer_ID”(autonumber) in "ClientTbl", add letters “PB” and use them for the “Client_nickname”(text) field and populate the rest with values set in the form (DateOfEvent (date), PlaceOfEvent (text), event (text) etc.) and repeat this as many times as set by the customer.

Example:

I would start with this ClientTbl table:

Client_ID - Client_nickname - DateOfEvent - PlaceOfEvent - Event
-----------------------------------------------------------------
1 - PB1 - 16.2.2011 - Boston - Annual Academy Award


After filling the form and sending the data it should look like this:

Client_ID - Client_nickname - DateOfEvent - PlaceOfEvent - Event
-------------------------------------------------------------------
1 - PB1 - 16.2.2011 - Boston - Annual Academy Award
2 - PB2 - 21.2.2011 - Los Angeles - My Academy Award 2011
3 - PB3 - 21.2.2011 - Los Angeles - My Academy Award 2011
4 - PB4 - 21.2.2011 - Los Angeles - My Academy Award 2011
5 - PB5 - 21.2.2011 - Los Angeles - My Academy Award 2011
6 - PB6 - 21.2.2011 - Los Angeles - My Academy Award 2011


If anybody can help I would by very grateful.
Peter