MULTIPLE FIELD LOOKUP TABLES

[gearhead03]

I AM FAIRLY EXPREIENCED WORKING WITH MS ACCESS WITH A LITTLE FORMAL TRAINING. I WORK IN THE TRUCKING INDUSTRY.
I AM ATTEMPTING TO USE A 5 DIGIT CODE (LETS CALL IT CUSTCODE) TO BRING UP MY CUSTOMERS NAME & ADDRESS IN A FORM SIMILAR TO AN INVOICE. THE NAME AND ADDRESS CONSIST OF 7 FIELDS. (NOT INCLUDING CUSTCODE) I CAN ONLY GET A LOOKUP FUNCTION TO DISPLAY 1 FIELD WHEN I ENTER CUSTCODE. WHEN I CLICK THE DROP-DOWN FOR THE LOOKUP IT DISPLAYS ALL 7 FIELDS BUT I CAN'T FIGURE OUT HOW TO MAKE IT DISPLAY AS SEPERATE FIELDS ON MY FORM & REPORT. I WOULD PREFER TO HAVE A SEPERATE TABLE FOR THE CUSTOMERS BUT WOULD PUT ALL THE DATA IN ONE TABLE IF NEED BE. ANY HELP WOULD BE APPRECIATED.

THANKS

 

[Trendsetter]

I'm assuming the Lookup is a combo and that you have 8 fields in there. The fields in a combo Rowsource are number from zero.
If you put a textbox on your form and call it CustName then in the control source of the Textbox type
=Forms!frmName!comboName.Column(1)

If the second column of the query has CustName then Column(1) will be CustName - this will be shown when you select an entry from the lookup.