Help Needed Fixing User ID

[aamer]

I have made a login form which had 5 users


everytime a user login, the login details are added in a LOGIN DETAIL TABLE
LOGIN DETAIL TABLE consists of the following fields
Login Sr
Login User ID
Login Date
Login Time
Login Date Time

Now the problem is I want to add the LOGIN USER ID in PURCHASE Table. every time an entry is made by a user. So I know who made that perticular entry.

can someone help me fix this issue

[pbaldy]

One way would be to store the logged in user ID on a form that will remain open, and have this as the default value for the field in the Purchase table:

=Forms!FormName.ControlName