J
Jan GT
Let's say I have a Form with four Controls. The Form has two Text
boxes and two Combo boxes for look up purposes. The Form is "linked"
to three Tables where table no 2 and 3 are related to table no 1.
Now, I want to add a List Box to the Form. How do I fill the List box,
with four columns, to show all the records in the List box? When I
tried with Sql, I got the values right for the first two columns, but
then only (the Combo boxes) list index for Columns three and four.
How do I do this so every Column is showing text and not indexes?
boxes and two Combo boxes for look up purposes. The Form is "linked"
to three Tables where table no 2 and 3 are related to table no 1.
Now, I want to add a List Box to the Form. How do I fill the List box,
with four columns, to show all the records in the List box? When I
tried with Sql, I got the values right for the first two columns, but
then only (the Combo boxes) list index for Columns three and four.
How do I do this so every Column is showing text and not indexes?