Form To Export Data And .....

Hi,

I am new, as you can see this is my first post. I have been reading different posts, but couldn't find a solution to my problem. Actually, I have created a table and around five forms, now each form is connected with that table. I can input the information through those forms into the table, now the only problem is this I want to transfer the information into differnt forms using the combo drop down menu, when the selection will be made it will transfer the information into the other or it will freez it into that form.

for e.g. I have made new, active, deal etc forms, I have made a drop down menu using combo which has these options in it as these are not only the forms name they are processes too. As the new deal comes in, it will be kept into new process for 30 days, after 30 days it should be moved to deal forms automatically, how would that be possible. And I want that to be frozen in that form. Other question is, how is it possible to hide the table from users, that they wont be able to make changes into table. Third question, once the info is inputed into the form no user should be able to delete that or overwrite it. And my last question is in regards to security, how is it possible to keep one user login into the database at one time, so no other user can login into that database or make changes.

I would really appreciate your help.

I hope I haven't conufused you guys.

Thanks