>Hi,
> I am trying to populate a combo box with 2 fields from a table. How do I the 2 fields into 2 records. Can I use sql statement and how ? thanks.
>sherry
You may try this:
1. Make sure the table you need the fields from are within scope.
2. In the ComboBox set the following properties:
2.1 ColumnCount = 2
2.2 RowSourceType = 3 && SQL Statement
2.3 RowSource = 'select field1, field2 from table'
HTH, I'm not sure if this is what you need though.
ramil
~~ learning to stand still