Help with Combo Box on Form

[DonkeyOte]

Hi - appreciate that for most of you guys what I am about to ask is a bit "Simple Simon" but I could do with some quick help...

I have a form created using the wizard - linked to a table called Invoice_Log

One of the fields on the form should contain a list of suppliers which is contained in another table entitled Supplier_Codes (field - "Name")

Now I obviously need this drop down to be linked to Table: Invoice_Log - and as such I have a field called Name in that table.

My problem is that this combo box doesn't display the names from Table:Supplier_Codes

Am I doing something really stupid (don't answer that )

Appreciate any help...

Luke

 

[Ifonly]

The combo box should have the following settings
Control source: (the name of the field that you want to fill)
Row source: (the name of the source) eg SELECT DISTINCTROW [supplier codes].[name] FROM [supplier codes];

 

[DonkeyOte]

Thanks...problem solved.