Please help me!!!

[delegence]

First off I would like to say hello to all. I would like to thank you for all your help in the past. My question is I am trying to use the current user Id to populate a text box and then I want to use that to update another text box and display the first name from a table named staff list.

Staff list contains the network id and the persons first and last name. If this is possible please help me. Thank you in advance

 

[SydneyGeek]

Just to clarify: do you want to place the CURRENT user's ID on the form, or do you want it so that they SELECT an ID and the other stuff populates the form?

If it's the first, then something like
[txtID] = UCase(Environ("UserName")) will do the job on a NT / Win 2K network, where txtID is the text box that you want to display the result. NOTE: This should be an UNBOUND control.

If it's the second option you want, consider using a Combo box. You could set up its SQL statement to have ID, FirstName, LastName, and other fields that you need.
Then add this code to the AfterUpdate event of the Combo:
[txtAnotherID] = Combo1.Column(0)
[txtFirstName]=Combo1.Column(1)
[txtLastName]=Combo1.Column(2)
etc.

You'd need to adjust control names to suit your situation.

Denis