Log in name in the record Entry Form

[rana1978]

Hello .....

I have developed an Inventory Database but facing some problem….

In the database there are some user names for entering the database. And the users have permission to input data. But I need to ensure the user names, who do input a specific data/record in the database. For this purpose it is necessary to show the user name (that is used for Login in the login Form) in the Data Entry Form and as well as in the main Database Table.

A sample of my database is attached herewith. It will be very much helpful if any one can help me in the above issue updating the attached database as per my need or giving a dami db.

Thanks

Rana

 

[Pyro]

If you just want to display the Username, you could use vba:

DoCmd.OpenForm "F_T_I_2"
Forms!F_T_I_2.Form!UserName = Me.cboEmployee.Column(1)
DoCmd.Close acForm, "frmLogon", acSaveNo

After the conditions of your login form have been met.

For the Location, you could use a Dlookup statement:

=DLookUp("Location","tblEmployees","strempname =  '" & [Username] & "'")

Hope this helps.