>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

Lincoln,
My apologies

I was attempting to answer another message and tabbed to this form somehow.
Robert