M
Mindy
I set the row source of a combo box to be three columns
from one table. I use the query design window and the
resulting SQL syntax is:
Select Table1.Field1, Table1.Field2, Table1.Field3 From
Table1
I have a column count of 3 on this combo and column width
of 1";0";0" so that only Field1 is showing. This works
great. I need those other columns for other things on the
form once a user makes a selection. The problem is, the
RowSource property keeps turning into all one column:
Select Table1.Field1, Table1.Field1, Table1.Field1 From
Table1
I did not change the row source. I just close/reopen the
form and/or the database and the row source has magically
changed itself. Any ideas?
from one table. I use the query design window and the
resulting SQL syntax is:
Select Table1.Field1, Table1.Field2, Table1.Field3 From
Table1
I have a column count of 3 on this combo and column width
of 1";0";0" so that only Field1 is showing. This works
great. I need those other columns for other things on the
form once a user makes a selection. The problem is, the
RowSource property keeps turning into all one column:
Select Table1.Field1, Table1.Field1, Table1.Field1 From
Table1
I did not change the row source. I just close/reopen the
form and/or the database and the row source has magically
changed itself. Any ideas?