Assigning values to a ComboBox from a Recordset?

[Chewypoo]

I have a recordset which is looksing up values from a table in another database (with the linking of the tablez). I now am be wanting to assign theses values to a combobox. Any ideas? Here's my code so far (pretty simple):

Dim dbs As Database, rst As Recordset, x As Integer
Set dbs = OpenDatabase("C:\OtherDatabase.mdb&quot
Set rst = dbs.OpenRecordset("OtherTable&quot
[MyComboBox].RowSource = ???

No ideaz what the ??? should be being! Any helpsies whould be helpfully helpful!

 

[bmoyer23]

If the tables are linked... do this:

[MyComboBox].RowSource = "OtherTable"

 

[Chewypoo]

Ahhh... my error! My error! I have mistyped the silly thing! I was meaning to say "withOUT the linking of the tablez" not with! So very sorry! I knowz that this would be the bestestest way if I was linking of the tables, but I cannot for the way this program must be programed!

So i say with out any further adooo... how does I make the fermenting thing working without these linking of the tables?!?

I somehwat am going bad over this!!

Thankyou for youre helpsies!