Add Fields To Form Based on Recordset

[Relwal]

I want to run a query to return client names and then list those clients on a form with a text box next to each one so a number can be input for each client and then updated in the db.



The part I don't know how to do, is to dynamically list the clients and add the textbox for each. I don't want to set up the labels and textboxes in advance because the number of records returned can be different each time.

I am competent with VBA, so happy to do it like that if that is what is required - I just can't work out a solution.

thanks in advance.
Kerry

[CJ_London]

sounds like you just need to use a continuous (multiple items) form