Multiple record saves

[hrg]

In my database i want to save a record. I can do this but what i want to do is when the user inputs information into the database via an entry form there is a text field at the end of the form which when a number is entered i want to save the information the same number of times inputted in the form.

e.g.

Form Name : FrmclientEntry

Name : John
Address : 50 stoney road
Address : high range
Address :
city : Birmingham
Post Code : 234524

Number of itmes : 4

So what i would want now is all this information to be saved 4 times in one table e.g

Table Name = Details

autonumnber Name Address etc

1 John 50 Stoney road
2 John 50 Stoney road
3 John 50 Stoney road
4 John 50 Stoney road

How can i do this?

 

[ziwacky]

I'm not sure why you'll like to do so, but one way could be using a For..Next statement.

Saying that your text box for number of times is called txtNmbTm,

Dim i as integer

For i = 1 to txtNmbTm
'Save your data
Next i

Hope that helps.

Z