Dynamic Text Boxes.. Possible?

[upgraders]

I am a seasoned ASP developer and I have been asked to
devlope a Budget calculator in MS Access. I need to be
able to Dynamically list an employee list and then in each
row have the form pull values from one of the tables and
enter them into the corresponding text box. This is so
that the value can be changed to calulate a "What if"
senerio. I can not use a List box so I need to create a
list of employees and tot he right of each emply have
about 5 or 6 values that are stored in the DB like "Rate"
1st Qtr Earnings 2nd Qtr earnings etc.. My question is
since there is going to be an "ever changing" list of
employees how can I dynamically generate the text boxes on
the form. In ASP I can simply create an array and do a
loop in the HTML code but in access I don't know where to
begin. Any suggestions? Thanks - Jason
.

 

[MikeAngelastro]

Use the form wizard to make a tabular form for the table.

 

[WayneRyan]

Jason,

You could consider using an unbound multi-
column text box. You could display only the name
making the widths of the other columns 0.

Its rowsource would be something like:

Select EmpName, Rate, Earnings1
From YourTable
Order by EmpName;

In the AfterUpdate event, you can move
the other values to the desired controls and
make your calculations.

Wayne