Hi.

In a sub-form, I want to display the names of companies. However the fields that are part of the table that is linked to the form, only holds the company's ID number. What I would like to display is held in another table where the ID, Company name and main contact are held.

At the moment I have the following in a textbox:

=DLookUp([sname],[TblAccountingBillToDropDownInfo],[FrmAccountingBillToDisplay].[AccountingBillToC]=[lID])


*************
[u]Legend</u>

sname = Is the field holding the Company name in the table holding
ID, Company Name and Main Contact

TblAccountingBill...Info = Is the said table

FrmAccounting...Display = Is the sub-form in which I wish to display

AccountingBillToC = Holds the Company ID I wish to look for

lID= the field in TblAccountingBill...Info which holds the company's IDs
*************


however this only displays #Name on the field.


Please Help.


Thanks.


LG

__________________
[LGuzman]

Good morning,
If I understand your question correctly, this should work:
In the design view of the form, go to the properties of the text box that you want the list in and click on the build icon next to "Row Source" property. This will bring up a screen for a SQL builder that looks like a query design view. Then only add the field of the Company name or what ever you want in the list for that field. That way it grabs that field and not the ID field.

Regards,
Laura

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!

Thank you for your help. Your advice pointed me to the solution.

LG

[LGuzman]