Can I have how many text boxes depends on how many records in a form?

[Aldred@office]

Hi,
I ran into a problem which I need to create a form which might have 20+
records from a select statement. One of the field will have a different
select statement depends on what have been selected before.

So, how may I develop a script which the form will generate textboxes
depends on how many records were fetched? Something like:

j=0
for each i in rs
j=j+1
create a textbox
textbox(j) = rs("Something")
rs.movenext
next

 

[Allen Browne]

If you bind your form, you won't have to generate more text boxes for more
records.

Just create a form in Continuous Form view. Place one text box for each
*field* you need to display, side by side across the form. Make the Detail
section just high enough to display this one row of text boxes.

When there are multiple records, it will show them, one above the other. You
don't need to create text boxes on the fly.

 

[Aldred@office]

THANKS, it works.

If you bind your form, you won't have to generate more text boxes for more
records.

Just create a form in Continuous Form view. Place one text box for each
*field* you need to display, side by side across the form. Make the Detail
section just high enough to display this one row of text boxes.

When there are multiple records, it will show them, one above the other.
You don't need to create text boxes on the fly.