Display user's database or record after login

[buienxg]

Hi there,



anybody knows how to display the user's record or database after he/she login in on the system. Currently I have a database where in the user enters his username and password. But the I dont know how can I make his records display after login. Any help help would be appreciated.

Regards,

[Toyman]

Where and how do you want to display the info. Lets say you have a main form that displays for the users to navagate through the db after log on. In the naagation form, you would create a field, lets say, "UserName". So in the code of the log on form, right after the user's access is validated, you would put a line of code to open the navagation form. After which you would put the code:

Dim sUser as String
sUser = Me.UserNameField 'this is the field in your log in that has the user's name
Forms!YourNavagationFormName!UserName = sUser