Search/Match and Display on Form

[ChronicFear]

Hello,

I think that I've read all of the posts about searching on this forum and they either aren't what I need to do or I'm too ignorant of VBA to understand them and I would really appreciate some help.

I have a form that opens when a user opens the database and I would like it to say "Welcome, <User's Name>!" I found some code on this site that searches Windows logon and returns the user ID that the individual using the database logged onto the network with. I also have a table that contains, among other things, both the network user ID for each person in my group and their name. For example:

mr2 Matthew
jk5 Janice

What I would like to do is have Access take the outputted network userID and match it to the first name, and then display that first name in the field on my opening form.

The outputted network ID is declared as "GetCurrentUserName", the field in the table containing that same information is declared "LoginID" and the field I want to have displayed on my opening page is called "FirstName".

Any help you can offer is greatly appreciated.

Thanks,
ChronicFear

 

[pbaldy]

The simplest way would be a DLookup, more info in Help. Here's a good reference on the syntax:

http://www.mvps.org/access/general/gen0018.htm

 

[ChronicFear]

Thanks, pbaldy! It worked like a charm. This is a classic example of trying to get too fancy with code when an easier solution already exists.