Help

[mugman17]

I am working on a system where the only way you can get a company's name on the confirm report is through a combo box (supplierID, suppliername). I have a buyer and a seller (both in combo boxes) seperated by an "and". I would like to create it so there is no spaces.

If I use a text box, I just get the Supplier ID number.

 

[David R]

If your supplier name/buyer name is in a separate table, as I suspect, and you're referencing that table through your combo box, you need to include that column from the other table in your query. Then put that field name in your report, instead of the lookup column.

HTH,
David R