Combobox Value To Display

[bd528]

Hi,

I have 2 table setup like :-

tbl1
SuppID
FirstName
Etc
Etc

tbl2
Supp_ID
SuppNum
Etc
Etc

The table are related by SuppID<->Supp_ID

I have a form where I want the user to find a record based on a combobox selection. Currently this works by selecting a SuppID from tbl1 as displayed in the combobox. What I want is the user to be able to select a SuppNum from tbl2 from the combobox. Is this possible? I've tried ammending the SQL statement for the combobox's row source, but I can't get the SuppNum to be displayed.

Thanks in advance.

 

[Minty]

What have you tried that didn't work - can you post up the SQL statement for the combobox, and any code that runs afterwards?

 

[bd528]

Here's what I'm using

SELECT tblQuotes.QuoteID, tblQuotes.Supply_ID, tblSupplies.Supply_Num
FROM tblSupplies INNER JOIN tblQuotes ON tblSupplies.SupplyID = tblQuotes.Supply_ID;

I changed the names in my original post, apologies. When I run the SQL, the Supply_Num displays, but I can't get it to display in the combobox

 

[Minty]

You need to make sure you have set 3 as the number of display columns in the combo box and set the widths for each column to display appropriately.

 

[bd528]

You need to make sure you have set 3 as the number of display columns in the combo box and set the widths for each column to display appropriately.

Doing that resolved my issue. Thank you for your help.

 

[Minty]

You are welcome !