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
.

create a table for the employees.

tab_employees.

and link the row source to the table, then the values would change everytime you change the table