textboxes (random)

[maravinds]

hi everyone,

i have a query which returns n number of rows. my problem is that i need to display the values in text box which is created automatically according to the number of rows returned in the same page(form).

for example if my query returns 1 row then 1 text box must be automatically created and then the value must be displayed and if my query returns 3 rows then 3 text boxes must be created and then the corresponding three values must be displayed.(on the same page).

is this possible?


aravind.s

 

[KeithG]

No, you can't quite do that but you could design a form with lets say 20 textboxes and then when you run your query you can assign values to each textbox and then the textboxes that are null you can set there visible property to false.

 

[maravinds]

hai keithG,

thanks for the reply. but how can i assign the first textbox to the first value in the query and the second text box to the second query and so on...

aravind.s

 

[KeithG]

It will have to be an unbound form and you will have to use the On open event to run the query, set your values, and then hide the null textboxes.