Combo box change on click

G

Gee...

I have a form that compares machines to each other.

When ComandComp is clicked I need ComboManuf to pic from a table called
"Manuf" and fill in the record "Ford".

I've gotten as far as:
Private Sub ComandComp_Click()
CombotManuf.RecordSource = "Manuf"

But that's as far as I got.


I'm sure this is a simple thing, I just can't see how to do it.
 
Top