I'm trying to design a login/password Form (Form1) used to verify and store the users name, login time, etc. in a table(UserTable). After a verified login the user can select one of several command buttons, each launching a different input form (Form2, Form3, etc.)and the amount of time the user is in the input form is supposed to be saved to another (LogTable).

With the interactive event of Form1 I locate/verify an existing record in the UserTable. The click event of Form1 inserts a new record in the LogTable including the user_id (from the UserTable),login(DateTime()), etc., it then launches Form2.

The init event of Form2 moves to the bottom of LogTable. The Form2.Destroy event replaces logout with DateTime(), lntimeinform = logout-login etc.

Three problems: 1) My Form2 will no longer allow more than one user access(and I thought I had solved my multi-user problems). 2) The logout data is not recorded in the LogTable(the field is empty). 3)The lntimeinform is not recorded in the LogTable(the field is empty).

I have spent hours trying to make this work with varying degress of success. I once had two out of three solved, but never all three and now I can't remember how I did that!

I know a real programmer wouldn't have these problems. Can anyone help?

TIA

--lincoln