BTW, my response a few minutes ago assumes Access 2003 or earlier. For 2007
or later the procedure will differ somewhat, but I do not have Access 2007 in
front of me, so I cannot provide specifics.

rp3886 wrote:
I am still new at trying to add the "bells and whistles" to Access.

I have a question concerning lookups. I have a database that has two tables:
BBBMembers and MemberTrainingLog. I also have a form named
MemberCPETrainingLog.

What I want to be able to do is this:

In the MemberCPETrainingLog form, I want to be able to input in the member ID
and have the corresponding member’s first name come up in the First Name
field of the same form. I also want the last name field in the form to be
filled in the same way. The function should look at the BBBMembers table for
the information.

Can this be done? I have tried looking at DLookups, but I am getting all
turned around. Thanks!


--
Message posted via http://www.accessmonster.com