I have a Access 2000 database that people use to report problems. currently when the form opens, the user types their LAN ID in the LAN ID text box and hits enter then all the other information (phone number, date, email etc is filled in from a query). How can I get the default value of the LAN ID to be the user's lan id at login time? We're running Windows NT...so the LAN ID has to be stored somewhere and able to be called from Access right? Any ideas?? Thanks!

Amy

Amy35 try this thread. I think it may contain an answer to your post.

Topic: Network User Name (http://www.access-programmers.co.uk/ubb/Forum1/HTML/007631.html)

There is also a function that allows you to grab the computers name here.

Topic: Interrogating the LDB (http://www.access-programmers.co.uk/ubb/Forum1/HTML/004114.html).

HTH Post back if you have more questions.

[This message has been edited by BukHix (edited 04-02-2002).]