copy/paste question

not really for sure if copy/paste is the word i am looking for. here is what i want to do i have a unbound form that has a lot (around 250) of unbound fields. what i am needing to do is i have a column of unbound fields named "employee1, employee2, etc:" where i put in the employees name. what i need it to do is after i click on the save button is save the names to the specified table (which it already does) but then i need it to recall the same names when i create a new record the following day instead of having the supervisors type in the names again day after day.

if this don't make sence i am sorry that is the best way that i know how to describe it.

thanks
chad

There is as many alternatives to do with this as your imagination will let you do it.

Here is a one that I would do.

You have your form set up to allow only 45 (or 46) people only.

I would create a table that lists the fields employee1...employee46. In this table input each employees name 1 thru 45. You put this information is a table as data so that it is easy to change leter down the raod

The you will add a button to your form that is labled "Setup up form", which you will use to get all the data from this new table and post it on your form, in your text boxes.


S-

that is what i want to do but i am not all that access/vb oriented. so if you could show me an example that would be cool.

and thanks in advance

I know you have a sample of my VBAUnbound DB.

Run the same code that is need to open a recordset for editing buy instead of pushing what is in the textboxes into the recordset doing the opposite

textbox = rsADO.Fields("record")

and don't update the recordset

S-

i have tried putting that code every where in my code but i get a error no matter where it is. i must be doing something wrong.

here is the database if you need to look at it since i made changes.

http://myfriendsofmo.com/op.zip

sorry for not understanding what you mean.
i am just learning access and vb. and thank you for your patience.

chad

Where did you put the code in your form so I can look at it.

S-