If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Having a difficult time with a lookup
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! -- Regina Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|