Variable number of lines on a form

[gellerche]

I have a form which has a recordset as its datasource. The recordset varies in length (sometimes more records, sometimes less), so I need a way to have the number of text boxes on the form change dynamically to match the recordset length each time the form is opened. If anyone knows how to do this, I would appreciate the help.

(PS: I have to select individual records on the form, so I can't use a report to solve this.)

Thank you,

Steve Geller

 

[Ernie Taylor]

Try using a subform. This gives you a scroll bar and allows you to have as many records as you need.

 

[gellerche]

Ernie:

Thank you for the advice. It works just fine (Sorry for the delay in thanking you, but I've never used subforms before, and it took me a while to figure it out.)

Steve