Load form with different values

[checoturco]

Hi all,

I have to build a form that depends of the records that´s are retrieved by a query that is made to DB.
The form must have the number of lines with some text box's as many the records is retrieved from the query, i.e. if the query brings me 5 records, the form must have 5 lines with some textbox's, if the query brings me 10 records the form must have 10 lines with some text box's.
i can do this with a continuous form but the user must insert a value in one of the text box´s and then, send/submit this value to DB.
I don´t know how to read each line of the text box's with a for or while loop in a continuous to insert then the values in DB.
If somebody have idea how to do this or can point me the right way i appreciate

tks all


checoturco

 

[Pat Hartman]

With a bound form, you don't need any code to update the table. You just enter data in a field and Access automatically saves it.