Hi Richard,

I have taken many of your courses and currently viewing Access 307, but it is not quite answering my question.  I have a form like this:

Phone Numbers------------------------
Business 800-555-1212
Business 2
Business Fax 800-555-1213
Home
Mobile 832-888-1212

Phone type (Business, Business 2…) needs to be glued to the phone number next to it.  PhoneType is a combo box.  I have a subform called frmPhoneNumbers, which has five fields—CompanyID, PhoneNumberID, PhoneType, PhoneNumber, and PhoneExtension.  If I choose a different PhoneType, I want the form to display the correct phone number or a blank if there is no phone number—such as, Business Fax will show a different phone number than the Business phone number or Home phone number.

I tried doing the DLookup, didn’t work and now I am lost.  

I tried to use the combo box feature in Access 2007 forms.  That is the:  Find a record on my form based on the value I selected in my combo box but it is not working.

Has this specific question been covered in any of your classes?

Any ideas on how I should set this up properly?

Thanks!