Combo box populate issue

[BrettM]

Within a database called "FB.mdb" I have two tables, a form and now a combo box problem.

The form gets most of its form data from a table called "Vouchers". It also has a two column Combo Box "WordType" which I would like to populate from the other table "CardTypes" which obviously also uses two columns "Field1" and "Field2" and a varying number of rows.

I have spent hours searching for ways to do this seemingly simple thing but have had little success to date.

Is this something anyone can possibly help me with please?

Thanks in advance,
Brett

 

[RuralGuy]

Did you use the ComboBox wizard to create the ComboBox for you? Did it not do the right job?

 

[BrettM]

Oops!

Whoops... was looking for the hard way as initial requirement was to get the data from an Excel file. Forgot all about the wizards.

Thanks for the nudge in the right direction RuralGuy.

 

[RuralGuy]

Glad to help. Post back here if you still need assistance.

 

[BrettM]

Still need some help

Hi RuralGuy,

All is now going according to Hoyle except for one small detail.

Re the combo box: I have bound the control to the second column as it is used to fill a text box. I still want the combo box to have a default value but it will only display if I set the bound column to the first column. Any ideas here?

 

[dsfcom]

BrettM; see you other post...

http://www.access-programmers.co.uk/forums/showthread.php?t=148639