KenHigg Kind of like a continuous subform?
yes ken, but i don´t know the way to read the value that user insert on the one of the text box's.
bat wrote
There is a limit to the number of controls that can be created on a form(regardless of wether they are deleted inbetween or not!) cant recal the figure but it is not that high.
can you create the 40 possibles normally and then control visibility to show just what you need?
i know. i already done that and i received that message of the limit, that´s why i wanna create the text box's one fly.
the major problem here is not show the values(code,description) , but insert the values that the user fill for the corresponding code.
example:
code,description, value are the text box's
code | description | value
1111 asdf 2 ( inserted by user)
1253 ergs 3
the code and description are the values retrieved from the db with the query,
the value is filled by the user to be inserted in the DB
I already think in create a group of text box's, i.e. if i have 15 records, i create 10 text box's and insert the values into db and then show the others 5 text box's